cell bg color vs. date

D

DKY

That's just it, I didnt want to do it per value of the cell. I wante
it to be based on the actual date. Like this, I just figured this ou
and it seems to work. If you see anything wrong with it, please let m
know.

=AND((TODAY())>=DATE(2004,10,25),(TODAY())<DATE(2004,10,27)
 
F

Frank Kabel

Hi
nothing wrong but you may remove some parentheses:
=AND(TODAY()>=DATE(2004,10,25),TODAY()<DATE(2004,10,27))
 

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

cell bg color vs. date 1
cell bg color vs. date 0
cell bg color vs. date 1
Show value from one cell in another cell if today falls between a date range 5
Conditional Formatting - Cannot get it to work, please help 1
Date Conditional Formatting 4
Color a cell based on column date and row content 2
display date of today in cell X when number >0 in cell Y 2

Top