Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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.

share|improve this question

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


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

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.