Difference Between Dates WITH Conditional Formatting

D

DOUG

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
 
M

mark

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditional Formatting Less Than Today Week Days only 0
Formatting a spreadsheet to calculate difference in dates etc. 2
Conditional formatting dates 3
Conditional Formatting 4th Condition 3
Conditional format if difference in cell values greater than 0.50% 1
Conditional Formatting Conundrum 3
Excel 2010 Conditional Formatting 2
Conditional format refers to two cells 1

Top