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

On Tue, 17 May 2011 06:27:32 -0700 (PDT), Kimbatigger <(E-Mail Removed)>
wrote:

>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.