Forum Discussion
Solved
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...
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.
Create a rule of type 'Use a formula to determine which cells to format' with the formula
=ISNUMBER(MATCH(221,testdone!$C:$C,0))
Your answer help me
If cell A8 contain a "text" and D8 contain a text that can be "closed" or "Open"
And i want to change the color of A8 based on D8 text, that is clear to me by using your used fourmla
My inquirry, but if i want to repeat above fourmla for each raw such as
A9 based on D9
A10 based on D10
A11 based on D11
and roll gose on