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 =O22N22 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.
--
David Biddulph

"Jeri" wrote in message
...
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.

--
Thank you.

Jeri


"John Bundy" wrote:

paste the formula you have in your conditional format condition
--
-John
Please rate when your question is answered to help us and others know
what
is helpful.


"Jeri" wrote:

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

Jeri


"Jeri" wrote:

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

Jeri