conditional format block

  1. E

    Conditional formatting of block of data

    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...

Some videos you may like

This Week's Hot Topics