Difference Between Dates WITH Conditional Formatting
 

I want cell C2 to turn RED if it is more than two days different than the
date in cell B2. Oddly, the formula "=B2-TODAY()2" works, but that is not
what I want to do. I want to say "=B2-C2()2", but the cell does not change
color. MS Excel just stared back at me. An exhaustive search of the www was
of no avail. Suggestions are welcome.

DOUG ECKERT
Wichita KS

Difference Between Dates WITH Conditional Formatting
 

for starters, try taking out the () in yoru C2() formula.

The () is a call to a formula, but C2 is a cell addres, not a formula

"DOUG" wrote:

I want cell C2 to turn RED if it is more than two days different than the
date in cell B2. Oddly, the formula "=B2-TODAY()2" works, but that is not
what I want to do. I want to say "=B2-C2()2", but the cell does not change
color. MS Excel just stared back at me. An exhaustive search of the www was
of no avail. Suggestions are welcome.

DOUG ECKERT
Wichita KS

Difference Between Dates WITH Conditional Formatting
 

=C2(B2+2)


Gord Dibben MS Excel MVP

On Tue, 18 May 2010 14:07:01 -0700, DOUG
wrote:

I want cell C2 to turn RED if it is more than two days different than the
date in cell B2. Oddly, the formula "=B2-TODAY()2" works, but that is not
what I want to do. I want to say "=B2-C2()2", but the cell does not change
color. MS Excel just stared back at me. An exhaustive search of the www was
of no avail. Suggestions are welcome.

DOUG ECKERT
Wichita KS