6

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.

1

1 Answer 1

9

If your Applies to field is set to A5:ZZ5 (or $5:$5 to highlight the entire row), your formula should be

=$J5="T"

Note where the $ is placed.

In my example below, my formula is set to =$J1="T" and my Applies to field is set to $A$1:$Z$6.

enter image description here

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .