If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|