Forum Discussion
Natalie907
Oct 30, 2020Copper Contributor
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 ...
Natalie907
Oct 30, 2020Copper Contributor
SergeiBaklan here is a sample file. I will try to apply your suggestion!
HansVogelaar
Oct 30, 2020MVP
See the attached version.
Click in J2 and select Conditional Formatting > Manage Rules... to view the conditional formatting rule.