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...
 
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

Excel VBA - counting cells by colors and names to it in two different rows. 0
Conditional Formatting 5
Date formatting 1
Date formula 3
Excel conditional formatting with Weeknum 4
Creating an update query that uses multiple parameters 2
Conditional Format with dates 5
Conditional formatting 1

Back
Top