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

This should be the simplest example of conditional formatting but I can't figure it out. I havave two columns seperated by several dozen other columns ('C'-original data, 'BO'- calculated value) and I need to highlight the calculated value if it is not equal to the original value. I can do this on a cell by cell basis but can't see how to apply it to a whole column withoug adding a rule for every row (there are many 1000s of rows).

What am I missing?

share|improve this question
You want to highlight values which are unequal to each other or those which are equal to each other? Your title and question body seem to be contradicting :S – Jerry Aug 27 '13 at 5:19
up vote 10 down vote accepted

I tend to use an IF() rule for this sort of thing. The trick is then to get the '$' signs right. If column C is the original data and BO is the calculated value, then select the BO column and add a conditional formatting formula rule of:


Note there is no $ sign beside the row number, which causes it to apply to each row in turn.

share|improve this answer

Select column BO and use the following:

share|improve this answer
Please be aware you have posted an answer to an old question that already has an accepted answer. This means your answer will not likely get any attention, nor be accepted. – CharlieRB Sep 21 '15 at 16:50

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.