Hi,
I'm trying to format each row in a block of data based on the entries in one column. So for example, in row 2, if cell E2 contains the words "complete" or "N/A", I want the text in all the columns in row 2 to be grey. Then the same with row 3, but with reference to E3, and so on.
Conditional highlighting seems the obvious choice, so I highlighted A2:E1000 and then put this formula into conditional highlighting:
=IF(OR(E2="complete",E2="N/A"),1,0)
and chose font colour grey.
This works, but only applies the formatting to column A. How do I get it to apply it to all the columns that I highlighted?
Thanks in advance for any help.
I'm trying to format each row in a block of data based on the entries in one column. So for example, in row 2, if cell E2 contains the words "complete" or "N/A", I want the text in all the columns in row 2 to be grey. Then the same with row 3, but with reference to E3, and so on.
Conditional highlighting seems the obvious choice, so I highlighted A2:E1000 and then put this formula into conditional highlighting:
=IF(OR(E2="complete",E2="N/A"),1,0)
and chose font colour grey.
This works, but only applies the formatting to column A. How do I get it to apply it to all the columns that I highlighted?
Thanks in advance for any help.