Forum Discussion
If 5 days since initial date, turn cell red
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.
- Natalie907Oct 30, 2020Copper Contributor
SergeiBaklan here is a sample file. I will try to apply your suggestion!
- HansVogelaarOct 30, 2020MVP
See the attached version.
Click in J2 and select Conditional Formatting > Manage Rules... to view the conditional formatting rule.
- Natalie907Nov 02, 2020Copper Contributor
HansVogelaar This is the right idea but I'm needing each cell to be dependent on the cell date in the same row.
Example based off the demo: I need column J dates, to coincide with the cell in the same row for column H.
"LE Recv" date + 7 (or 5 business days) and anything beyond to turn the cell red that's in in the same row but in the "Submit" column J.
Do I need to manually go in to make each cell coincide with the cell in the same row? Or can I create a formula for the whole table?