If/Then formatting

  • Thread starter Thread starter John
  • Start date Start date
J

John

Novice here

I would like to highlight/color a cell if the number of that cell exceeds
the number of the cell next to it. The cell I would like to color already has
a formula for adding in it.

Any help is greatly appreciated

John
 
Here is an example for B1. If B1 is greater than A1, we want B1 highlighted:

Click on B1 and:
Format > Conditional Formatting... . Formula Is >

=B1>A1

and then pick a nice color.
 
HI John
Go to ' Format/Conditional Formatting/ select "Greater Than or your choice
and next window select the cell reference eg: =A2
Regards
Cimjet
 
Back
Top