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

What is the last column in Excel?
Excel columns run from A to Z, AA to AZ, AAA to XFD. The last column is XFD.

StephenCrump

MrExcel MVP
Joined
Sep 18, 2013
Messages
4,117
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,127,352
Messages
5,624,173
Members
416,017
Latest member
moritz210

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