| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Coloring a cell based off the color of another cell
Is there a way for conditional formatting to recognize a color of a cell and
then color another cell if that color appears in a cell? i.e. if D1 is colored RED, then H1 is colored either RED or a different color -- Eric |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Coloring a cell based off the color of another cell
Use Conditional formatting (formula is) on the "another cell" so what
ever the criteria in D1 is, use the same in H1 but use formula is, instead of Cell value is. Eric D wrote: Is there a way for conditional formatting to recognize a color of a cell and then color another cell if that color appears in a cell? i.e. if D1 is colored RED, then H1 is colored either RED or a different color |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Coloring a cell based off the color of another cell
how does this work in office 2007?
-- Eric "Bob I" wrote: Use Conditional formatting (formula is) on the "another cell" so what ever the criteria in D1 is, use the same in H1 but use formula is, instead of Cell value is. Eric D wrote: Is there a way for conditional formatting to recognize a color of a cell and then color another cell if that color appears in a cell? i.e. if D1 is colored RED, then H1 is colored either RED or a different color |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Coloring a cell based off the color of another cell
Have you tried F1?
Eric D wrote: how does this work in office 2007? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Coloring a cell based off the color of another cell
i can't find anything that tells me how to do that in the HELP data.
-- Eric "Bob I" wrote: Have you tried F1? Eric D wrote: how does this work in office 2007? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Making a Cell turn color based on results in another cell | Excel Discussion (Misc queries) | |||
| Excel: Syntax to change cell color based on color of another cell | Excel Worksheet Functions | |||
| Format cell color based on multiple cell values | Excel Discussion (Misc queries) | |||
| Format cell color based on multiple cell values | Excel Discussion (Misc queries) | |||
| Conditional coloring of Excel cells, based on adjacent cell values? | Excel Worksheet Functions | |||
Linear Mode
