Click on C3 then Format | Conditional Formatting. In the panel that
pops up, select Formula Is rather than Cell Value Is in the first box,
and then enter this formula:

=AND($C3<"",$C$1<"",$C3$C$1)

Then click the Format button, click on the Patterns tab (for
background colour) and click Orange, then click OK.

Click Add for a second condition, Formula Is again, and then enter
this formula:

=AND($C3<"",$C$1<"",$C3<$C$1)

then click on the Format button and select Light Blue for the colour.
Then click OK twice to escape the CF dialogue.

If the two dates are the same there will be no change in format,
otherwise you will get an orange background for a later date in C3 and
a light blue background for an earlier date, but only if both cells
are not empty.

If you wish, you can use the Format Painter to apply this format to
other cells on the same row.

Hope this helps.

Pete

On Mar 12, 7:11*pm, LiveUser
wrote:
I did that, but it copies the condition and cell. I want the cell to change.
Maybe I am confused.



"Bernie R." wrote:
click on the cell with the conditional format that you want, then click on
the "paintbrush" in the toolbar and then left click and "drag" over the cells
you want the conditional formula to be in.

"LiveUser" wrote:

That worked fine. Thank you. Is there an easy way to copy this condition to
other cells, but have the refer to cell change?

"justlearnin" wrote:

Use conditional formatting for this one

"LiveUser" wrote:

If the date in cell C3 is after date in cell C1, then color cell orange.

If this is possible then can I do this:

If the date in cell C3 is after the date in cell C1, then color cell orange
and If the date in cell C3 is before the date in cell C1, then color the cell
light blue.

Thank you.- Hide quoted text -

- Show quoted text -