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.

--
Thank you.

Jeri


"David Biddulph" wrote:

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