Forum Discussion
Solved
How to format a cell that has a date less than 30 days from another date in a different cell
I would like to have a cell show a color if the date is 30 days less than another date in a different cell. Form instance, if cell I33 says February 16, 2022 and cell G33 says Feb 22, 2022, how to I...
Select I33.
On the Home tab of the ribbon, select Conditional Formatting > New Rule...
Select 'Format only cells that contain'.
Leave the first drop down set to 'Cell Value'.
Select 'greater than' from the second drop down.
Enter =G33-30 in the box next to it.
Click Format...
Activate the Fill tab.
Select a color.
Click OK, then click OK again.
Select I33.
On the Home tab of the ribbon, select Conditional Formatting > New Rule...
Select 'Format only cells that contain'.
Leave the first drop down set to 'Cell Value'.
Select 'greater than' from the second drop down.
Enter =G33-30 in the box next to it.
Click Format...
Activate the Fill tab.
Select a color.
Click OK, then click OK again.
Thanks very much!!