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.