Forum Discussion
How do I make excel change the colour of a cell depending on a different cells date?
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.
Select A8:A100 (or as far down as you want).
A8 should be the active cell in the selection.
On the Home tab of the ribbon, click Conditional Formatting > New Rule...
Select 'Use a formula to determine which cells to format'.
Enter the formula
=D8="Closed"
Click Format...
Activate the Fill tab.
Select a highlight color.
Click OK, then click OK again.
Repeat these steps, but with the formula
=D8="Open"
and another color.
Hey! This is all great info!
I am trying to make a visual to do list and I was wondering how to make a cell turn a different colour based on if a check box is checked off. For example, in column A I have various to do list items written, column B has check boxes and column 3 I am wanting to make the box turn green when the check box is checked off.
Any help is appreciated! Thanks!
Do the check boxes have a linked cell? If so, which cells do you use for that?