Conditional Formatting

[colin5392]

OK, I have a table set up, R10:Y16,
1-7
8-14
15-21
22-28
29-35
36-42
43-50


which has conditional formatting set up, based on values listed within R9:V9.


So, I have another table on the same worksheet, R18:Y24, which contains completely different values.


My query is: where cells are highlighted in the first table, how do I get the associated cells in the second table to be highlighted at the same time?


The CF set up for the first table is: =SUM(--(R10=$R$9:$V$9))>0
which applies to =$R$10:$Y$16


Can you help?

 

[FDibbins]

Try using the same rule, based on the 1st table, but having the 2nd table as the "applies to"