cell color in conjunction with upcoming date

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

im new to excel and im trying to create a formula that changes the color of a
row when the due date for one of my tool inspections comes within 30 days of
todays date
 
Highlight the columns with the dates in it. Now go to FORMAT>CONDITIONAL
FORMATTING. The condition that you want to set is where:

"Cell Value Is" "between" "=TODAY()-1" and "=TODAY()+30"

Then hit the FORMAT button to choose a PATTERN (color) for cells meeting the
above calculated criteria. The formula will return all cells equal to today
and within or equal to 30 days from today.

Hope this helps.
 
that worked great thanks

BriSwy said:
Highlight the columns with the dates in it. Now go to FORMAT>CONDITIONAL
FORMATTING. The condition that you want to set is where:

"Cell Value Is" "between" "=TODAY()-1" and "=TODAY()+30"

Then hit the FORMAT button to choose a PATTERN (color) for cells meeting the
above calculated criteria. The formula will return all cells equal to today
and within or equal to 30 days from today.

Hope this helps.
Click to expand...
 
Back
Top