Forum Discussion
If 5 days since initial date, turn cell red
Hi there, I'm a beginner when it comes to excel and am needing some resources/guidance. I need to find a way (I'm not sure whether to use "If" or "conditional") to make the cells in column J to ...
Select J2:J100 (or however far down the data go).
I will assume that J2 is the active cell in the selection.
On the Home tab of the ribbon, click Conditional Formatting > New Rule...
Select 'Format only cells that contain'.
Leave the first dropdown set to 'Cell Value'.
Select 'greater than' from the second dropdown.
Enter the formula =G2+5 in the box next to it.
Click Format...
Activate the Fill tab.
Select red.
Click OK, then click OK again.