Prev: Pivot Item Displaying Incorrect Value?
Next: Help with data points in line graph in Chart function in Excel.
From: DOUG on 18 May 2010 17:07
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
From: mark on 18 May 2010 17:11
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
From: Gord Dibben on 18 May 2010 17:25
=C2>(B2+2)


Gord Dibben MS Excel MVP

On Tue, 18 May 2010 14:07:01 -0700, DOUG <DOUG(a)discussions.microsoft.com>
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

 | 
Pages: 1
Prev: Pivot Item Displaying Incorrect Value?
Next: Help with data points in line graph in Chart function in Excel.