Changing cell bakground color to match another cell

Brew

Well-known Member
Joined
Sep 29, 2003
Messages
1,569
If AA5:AC24 and AD5:AF24 are compose of 3 cell digit groups as well as various cells in
B10:D150. How do I create a macro that will match the 3 cell digit combinations in B10:B150
with those 3 digit cell combinations in AA5:AC24 and AD5:AF24. If the match is AA5:AC24 and AD5:AF24
is true, then change the background color to match the digits in the cell.

Example:

B13:D13=0,3,8 (0 & 3 are red background and 8 is default background)
AA7:AC7=0,3,8 (B13:D13=AA7:AC7)
therefore, change cell AA7=0 and AB7=3 to red background.
Thanks
 

Excel Facts

Back into an answer in Excel
Use Data, What-If Analysis, Goal Seek to find the correct input cell value to reach a desired result

goblin

Active Member
Joined
Apr 16, 2003
Messages
469
Select cell AA13 and use the following as a formula in conditional formatting:

=AND($B13=$AA13,$C13=$AB13,$D13=$AC13)

Copy the format to all relevant cells
 
Upvote 0

Forum statistics

Threads
1,187,173
Messages
5,962,033
Members
438,576
Latest member
Cstewart29

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