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 th...
=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.