Forum Discussion
Solved
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 ca...
- 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.
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.
Then in the formula box use:
=(E1>Today())*(E1<(Today()+30))
Make sure to click Formatting and select the background color you want.
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!
I appreciate the assistance!