Tuesday, 23 April 2019

microsoft excel - Conditional formatting to highlight the whole row

I would like to highlight the whole row 5 if J5="T".


I used to do it with the old Excel, the 2010 conditional formatting ignores it. So my rule is like this and it does not work. I used the formula $J$20="T", apply to A5:ZZ5, or $5:$5 — nothing works.


It is supposed to change the format if the result of the formula is true, so if it is anything else than a "T" it should not highlight/change the format.


The formula was simple and it worked before, now it can not understand it.

No comments:

Post a Comment

How can I VLOOKUP in multiple Excel documents?

I am trying to VLOOKUP reference data with around 400 seperate Excel files. Is it possible to do this in a quick way rather than doing it m...