SOLVED

New Contributor

# Change the color of a cell based on a range of dates

I have a spreadsheet in which Column E is calculating a date based upon a date entered in Column A and adding a set number of days to it.

I wish to have column E shaded to a given color if the calculated date is between today and 30 days from now

3 Replies
best response confirmed by mtarler (Trusted Contributor)
Solution

# Re: Change the color of a cell based on a range of dates

Select column E and then go to Home->Conditional Formatting and Add New and then select Based on Formula.
Then in the formula box use:
=(E1>Today())*(E1<(Today()+30))
Make sure to click Formatting and select the background color you want.

# Re: Change the color of a cell based on a range of dates

Thank you it was the * that I was missing, but you also have one extra ")" at the end of your formula.

I appreciate the assistance!

# Re: Change the color of a cell based on a range of dates

You're very welcome. Alternatively you could use AND().
As for having an extra ")" in the formula I don't see it, but since you got it to work i will close this out for you