Automatically Formatting a Cell Based on the Color of Another Cell

citrus

New Member
Joined
Jan 15, 2021
Messages
2
Office Version
  1. 365
Platform
  1. Windows
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.
 

Some videos you may like

Excel Facts

Square and cube roots
The =SQRT(25) is a square root. For a cube root, use =125^(1/3). For a fourth root, use =625^(1/4).

StephenCrump

MrExcel MVP
Joined
Sep 18, 2013
Messages
4,046
Office Version
  1. 365
Platform
  1. Windows
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?

AB
1CheckStuff
2xBlah
3Blah
4Blah
5xBlah
6Blah
7Blah
8xBlah
9Blah
10xBlah
11
12
Sheet3
Cells with Conditional Formatting
CellConditionCell FormatStop If True
A2:B10Expression=$A2="x"textNO
 

citrus

New Member
Joined
Jan 15, 2021
Messages
2
Office Version
  1. 365
Platform
  1. Windows
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?

AB
1CheckStuff
2xBlah
3Blah
4Blah
5xBlah
6Blah
7Blah
8xBlah
9Blah
10xBlah
11
12
Sheet3
Cells with Conditional Formatting
CellConditionCell FormatStop If True
A2:B10Expression=$A2="x"textNO
Yeah, I just couldn't figure out a function to use that would work.
 

Watch MrExcel Video

Forum statistics

Threads
1,123,265
Messages
5,600,605
Members
414,394
Latest member
mahendar

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top