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.
rizaldi_riz395
Oct 19, 2022Brass Contributor
Daniel Cook Try this simple trick
:
howhide.com/simple-trick-to-make-excel-change-colour-cell-depending-on-different-cells-date