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 ...
You may apply conditional formatting rule to the column "Submit" of the table with rule formula as =$J2>$G2+5.
If you provide sample file instead of screenshot it'll be easier to illustrate.