Forum Discussion
Conditional formatting to change color for 15 days after specific date in cell
Hi all,
kindly can I ask for some help? I am trying to achieve the following by conditional formatting:
- I have a column with different dates in each cell. I would like when the date hits the cells to change their color for exactly 15 days after the date specified in the cell.
Eg. Today is 01/27/2023 and till today the cell had normal formatting. From tomorrow it will change it's filling color to red for example for exactly 15 days. So the color will be triggered by the date in each cell. Hope I explained it clear enough!🙂
Regards,
Emil
1 Reply
=AND(TODAY()>=A2+1,TODAY()<=A2+15)You can try this rule for conditional formatting.
=$A$2:$A$7This is the range the formatting applies to in the example.
