Apr 17 2019 09:07 AM
Hi
I am trying to format a row of data so that it greys out if I enter certain text into another cell.
Example: If I type a letter in column H then all the columns (A-H or A-G if it's easier) in that row grey out.
Apologies if this has already been asked and thanks in advance.
Barry
Apr 17 2019 10:13 AM
@BEphgrave , use a rule formula like =$H1=<your text> and apply it to your entire range. (or $H# if your range starts from # row). It's important to acre about absolute and relative references in your formula.