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 FORMATCONDITIONAL
FORMATTING. The condition that you want to set is whe

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

"Will Ruckel" wrote:

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

that worked great thanks

"BriSwy" wrote:

Highlight the columns with the dates in it. Now go to FORMATCONDITIONAL
FORMATTING. The condition that you want to set is whe

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

"Will Ruckel" wrote:

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