conditional formatting for deadlines

[Injinia]

hi,


I have a list of items each with a different deadline, thus a new deadline for every row. I have a separate column for when the item is done. so column C = deadline and column D = date done


How would I go about setting a conditional format for this data such that

- if the done date is before the deadline, the text is green,

- if the done date is +2 days the deadline, the formatting is yellow,

- and if the done date is before the deadline then the formatting is is green


Regards, Injinia

 

[PSG]

D2<C2 format this as green

=(D2-2)=C2 format this as yellow


Your third condition is similar to the first one. Please confirm if this is what you wanted to ask.