Forum Discussion
Daniel Cook
Aug 24, 2017Copper Contributor
How do I make excel change the colour of a cell depending on a different cells date?
Hi, How do I make excel change the colour of a cell depending on a different cells date? Turn A2 red if - E2 cell is smaller than todays date Turn A2 yellow with red outline if - E2 ce...
- Nov 21, 2022
Let's say you want to highlight a row if column F contains "Closed".
Use the formula
=$F2="Closed"
If you want something different, please provide more detailed information.
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