![]() |
How to make a cell equal another cells colour?
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 |
How to make a cell equal another cells colour?
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 |
How to make a cell equal another cells colour?
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 . |
How to make a cell equal another cells colour?
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 "Sam.D" wrote: 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 . |
All times are GMT +1. The time now is 12:38 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com