How to make a cell equal another cells colour?

[Sam.D]

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

 

[Luke M]

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

 

[Sam.D]

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

 

[Reg]

in the conditional formatting for the second group change it to 'formula is'
and then create a formula using the first group of cells with the same
evaluation criteria as before. For example:

select cell 'A2'
Format, conditional formatting,
chage default (cell value is) to Formula is
in the formula box put '=and(a1=1, b1=2);'
and so on
then put formatting as before.

hth

regMigrant