Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 . |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
can I make cell "yes" equal 1, "no" equal 0 | Excel Discussion (Misc queries) | |||
How to equal a cell in another worksheet incl fill colour | Excel Worksheet Functions | |||
How do I make a range of cells in a column equal to another cell | New Users to Excel | |||
How do I make a range of cells equal to one cell | Excel Discussion (Misc queries) | |||
How do I make a cell equal to another cells value and not it's fo. | Excel Worksheet Functions |