conditional formatting with dates

  • Thread starter Thread starter Frank stone
  • Start date Start date
F

Frank stone

Hi,
try this:
condition 1
cell value is between =Today()+30 and =today()-30
text font = green
conditin 2
cell vaue is < =Today()-30
text font = red
I tried on this dates
7/15/04 =red
8/26/04 = green
9/30/04 = black
:)
 
Thanks

Frank stone said:
Hi,
try this:
condition 1
cell value is between =Today()+30 and =today()-30
text font = green
conditin 2
cell vaue is < =Today()-30
text font = red
I tried on this dates
7/15/04 =red
8/26/04 = green
9/30/04 = black
:)
Click to expand...
 
You must log in or register to reply here.

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 formating 3
conditional Formatting help 2
Excel 2003 - Adding up cells that contain Conditional Formatting 10
Excel Formatting with dates 3
if then and conditional formatting of dates 2
several conditional formats for dates 4
Writing Formula For conditional Formatting Using Excel 2000 3
conditional formating dates, please help me 1

Back
Top