Excel 2007 comparing dates

[Jeri]

I have two columns and I want to compare the dates in the columns and then
format the cell to be to Red if column B is greater than column A.

So far, it seems that I can only do this on a per cell basis and not for the
whole column. Excel 2007's conditional formating is much harder for me to
get used to. Any help you could provide would be appreciated.

 

[Jeri]

To clarify, I can get it to do it on a single cell, however, I cannot get the
formula to work on the whole column without doing it on each individual cell.

Thank you.

 

[John Bundy]

paste the formula you have in your conditional format condition

 

[Jeri]

This is the format for One Cell =$O$22>$N$22 but I need it to check all the
dates in N against O dates and then color them if N is less than O. I don't
know how to get it to do it for all the cells in N.

 

[David Biddulph]

If you want to compare each N cell against the corresponding O cell in the
same row, get rid of the absolute row references.
You don't want =$O$22>$N$22 but =$O22>$N22 (or even just =O22>N22 if you are
not trying to copy across columns).

If you are confused as to what the $ signs do, look up absolute and relative
addressing in Excel help.

 

[Jeri]

Thank you, I did remove the $ to see if that helped, but it did not allow me
to copy the conditional formatting formula in to all N cells

So for example my current work sheet has rows 3 thorugh 35 that I want to
compare, but sometimes I actually have hundreds of rows. I need to some how
have it compare all of them and the only way it seems to allow me to do it
now is to put the conditional formatting on each cell. In Excel 2003 I did
not have this problem, it worked much easier, and I don't know if it is just
because the way things changed in Excel 2007 or if I am just "not getting it".

Thank you.