Unfortunately that won't work as the 2 sets of cells have different values
ie: the first set are variable numbers and the second set are dates.

I want the 2 scale colour on the set of variable numbers to overlay onto the
set of dates without changing based on the date value.

Sorry if I'm not explaining this very well.

Thanks for your help

Sam.D

"Luke M" wrote:

Have them use the same conditional format rules, simply references the cells
they are "mirroring".

--
Best Regards,

Luke M
"Sam.D" wrote in message
...
I have conditional formatting on a set of values to highlight high/low
values
using a 2-colour scale.

Is there a way I can get another set of cells to mirror the colour alone
without changing their values?

Many thanks in advance

Sam.D


.