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.
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.
I have two sheets that are connected with formulas,when I change data in sheet 1 it changes in sheet 2.I want to ask what do I have to do,when I change data in sheet 1 to appear in another colour in sheet 2.
You can use conditional formatting referring to the values of the cells on Sheet2, just like when you enter the data there directly.