Forum Discussion
kuzettedt
Aug 11, 2025Copper Contributor
Conditional Formatting Days since Date
I have a client spreadsheet and I am trying conditionally format the cells to highlight in color based on the number of days that have passed since the "Drop off" (Column F) in the same cell/column (...
HansVogelaar
Aug 11, 2025MVP
Your description confuses me. What does column F contain and what does column J contain?
And which column do you want to format conditionally?
kuzettedt
Aug 12, 2025Copper Contributor
Hi Hans
Column F contains the drop off date, Column J contains the formula F27+10. My problem is that they want column J to change color according to how many days has passed from the drop off date.
Yellow +10 Days
Orange +12 Days
Red +14 Days
Would I need to make an extra column to accommodate the +12 and +14 days or is it possible to combine everything in one formula?
I hope this makes more sense