Conditional Formatting, Dates, and "Fill Column"

[cht13er]

I searched through old topics, but they didn't help me - I think I am
missing a crucial idea.

I have dates in cells A1:A20, B1:B20, and C1:C20.

What I want to do is format any cells in columns A and B that show
dates later than the date in column C. Example:

If A1 is 10-Jan-05, B1 is 21-Jan-05, and C1 is 14-Feb-05, no cells are
formatted.
If A2 is 12-Jan-05, B2 is 22-Jan-05, and C2 is 02-Jan-05, cells A2 and
B2 are both formatted.
If A3 is 27-Feb-05, B3 is 09-Mar-05, and C3 is 07-Mar-05, only cell B3
is formatted.

So basically I am going row by row and finding dates in columns A and B
that are later than the date in column C.
I can't get it to work without going cell-by-cell and putting a
different formula in each cell. (Of which there are 2x20=40.) Help!!

A caveat - because of some network issue, I can't use VBA. Conditional
formatting formulas only!

Thanks,
Cht13er

 

[SteveG]

Hi,

In cell A1

Formula is:
=A1>C1

In cell B1

Formula is:

=B1>C1

Be sure to remove the absolute reference ($) signs. Otherwise when you
copy it to the others, your reference cells won't cahnge.

Select fill color. Click ok to apply.

Highlight cells A1:B1, select the format painter and highlight A2:B20.
This will apply to all the cells keeping the references in order down
the range.

Cheers,

Steve

 

[cht13er]

OK, this answer was so incredibly easy that I feel kinda dumb....of
course your solution worked like a charm.

Thanks, Steve!
cht13er