Forum Discussion
SergeiBaklan
Aug 24, 2017MVP
Hi Daniel,
In your screenshot there is no any date in E2. But in general
Stay on A2, Home->Conditional formatting->Manage rules->New ruke; use for the ruke
=$E2<=TODAY()
Format, apply any formatting you want. After that apply the rule to entire range (e.g. $A$2:$A$10), or keep only A2.
Repeat for each color /condition you'd like to have