I would like to use conditional formatting to highlight a specific row in RED from $A$7:$AY$138
Based on the condition, which is already established: For all the row numbers that have TRUE within =ROWS()=$AZ$7:$AZ$138
but this condition doesn't work, I don't know how to write it!
So what I have in column AZ looks like this:
ROW / AZ
7 / FALSE
8 / FALSE
9 / TRUE
10 / FALSE
11 / FALSE
12 / FALSE
13 / TRUE
....and so on until row
138
In the example above, rows 9 and 13 displayed TRUE, and I want those rows to be in RED (within columns A:AY).
Please help! Thanks!
-Nenad
Bookmarks