thanks in advance for help with the following:
I have a spreadsheet with 10 columns of data. I currently have a conditional formatting rule where if value in Column A is HIGH PRIORITY, column A is highlighted in Red. However, I'd like to expand the rule so that if Column A = HIGH PRIORITY, the row (columns A - J) is Highlighted in Red.
Any help would be greatly appreciated.