Conditional Formatting (Colour Scales) between separate cells on different rows

[Detrus]

Hello,

I've a sheet with 9 tables in it. At the base of each table is a cell highlighting the total in that table. The tables are set out on different rows (see image)

I'd like to set up a conditional format, preferably a Coloured Scale, to highlight the range between all total cells, however at the moment I can only work out how to compare the range across one row. I've tried using the Paste Format tool but that just pastes the conditional format based on the row.

Any ideas?

 

[Peter_SSs]

Try this

Set up CF with your preferred colour scale conditional formatting on the first total cell. For my dummy layout it looks like this

20 04 11.xlsm
	A	B	C	D	E	F	G	H	I	J
1
2
3
4
5
6
7
8
9
10	3				64				8
11
12
13
14
15
16
17
18
19	35				7				1
CF Colour Scale

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A10	Other Type	Color scale		NO

Go back in to the CF dialog of Manage rules

and edit the 'Applies to' range to include the (top left) cell of the other total areas. For me that is

and the results is

20 04 11.xlsm
	A	B	C	D	E	F	G	H	I	J
1
2
3
4
5
6
7
8
9
10	3				64				8
11
12
13
14
15
16
17
18
19	35				7				1
CF Colour Scale

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A10,E10,I10,A19,E19,I19	Other Type	Color scale		NO

 

[Detrus]

Thank You!! Had a feeling it'd be something simple like that. Greatly appreciated!!

 

[Peter_SSs]

Thank You!! Had a feeling it'd be something simple like that. Greatly appreciated!!

You're welcome. Thanks for the follow-up.