Automatically Formatting a Cell Based on the Color of Another Cell

[citrus]

Hello, I am trying to make a checklist which I have set up by having each task in its own cell with another cell next to it to act as a checkbox. I want to make the background color of the task cell and the checkbox cell change to green whenever I place an "X" in the checkbox cell. It was very easy to use the conditional formatting and make the checkbox cell turn green, but I can't figure out how to automatically configure the task to change color when the X is placed. I have conditional formatting on the entire sheet so that whenever a cell's value is "X," its background color changes to green. Copying the formatting of the cell onto the task cell wouldn't work because the task cell has words in it and not just "X." I can't find anything about how to only copy the color of another cell and I can't think of any way to do it. It's probably possible through the coding Excel uses but I don't know how to do that. Thanks for any help you can give.

 

[StephenCrump]

Welcome to the Forum!

When you conditionally format, the bottom option allows you to use a formula. I think you're looking for something like this?

	A	B
1	Check	Stuff
2	x	Blah
3		Blah
4		Blah
5	x	Blah
6		Blah
7		Blah
8	x	Blah
9		Blah
10	x	Blah
11
12
Sheet3

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A2:B10	Expression	=$A2="x"	text	NO

 

[citrus]

Welcome to the Forum!

When you conditionally format, the bottom option allows you to use a formula. I think you're looking for something like this?

	A	B
1	Check	Stuff
2	x	Blah
3		Blah
4		Blah
5	x	Blah
6		Blah
7		Blah
8	x	Blah
9		Blah
10	x	Blah
11
12
Sheet3

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A2:B10	Expression	=$A2="x"	text	NO

Yeah, I just couldn't figure out a function to use that would work.