Conditional Format-should be an easy answer

  • Thread starter Thread starter Kimbatigger
  • Start date Start date
K

Kimbatigger

I have a spreadsheet with two columns of numbers.
I want to highlight the number in the second column if it is greater
than the number in the first column.
e.g. If c3 is greater than a3, highlight, and then if c4 is greater
than a4 and so on.

I was able to do this quite easily in XL 2003, but have been stymied
in XL2007.
I realize this is a rudimentary question, but I just can't seem to
figure it out, and have searched many help sites.
Thanks for any help.
 
Select the range of cells in column C

Home Tab>Conditional Format>New Rule>Select a Rule Type>Use a Formula

=$C1>$A1

Format to a Fill color of your choice and OK.


Gord Dibben MS Excel MVP
 
Back
Top