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

Shade all formula cells
To shade all formula cells: Home, Find & Select, Formulas to select all formulas. Then apply a light fill color.

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
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,152,100
Messages
5,768,095
Members
425,452
Latest member
htay44

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