I would like to highlight the whole row 5 if
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
$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.