Changing cell bakground color to match another cell

[Brew]

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

 

[goblin]

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

 

[Brew]

I will test it.

Regards,