Conditional Formatting

colin5392

Board Regular
Joined
Oct 25, 2016
Messages
56
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?
 

Excel Facts

How to total the visible cells?
From the first blank cell below a filtered data set, press Alt+=. Instead of SUM, you will get SUBTOTAL(9,)

FDibbins

Well-known Member
Joined
Feb 16, 2013
Messages
6,723
Try using the same rule, based on the 1st table, but having the 2nd table as the "applies to"
 

Watch MrExcel Video

Forum statistics

Threads
1,130,307
Messages
5,641,436
Members
417,209
Latest member
Agbarker

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