Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2007: cell shading (not conditional formatting)
cell A1 is shaded green. I want cell C1 to be shaded the same color as A1.
When cell A1 is changed to yellow, cell C1 should also change to yellow. Help? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2007: cell shading (not conditional formatting)
select a1 and then do hold ctrl key down when you click C1. this called a
discontiguous slection or something like that. now when you change a1, c1 also change because it also selected. if maybe you want someway link theses formats together so change to one is automatic to other i think that not possible. except if you decide to use conditional formats with both cell have same condition. "youngst2010" wrote in message ... | cell A1 is shaded green. I want cell C1 to be shaded the same color as A1. | When cell A1 is changed to yellow, cell C1 should also change to yellow. | Help? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 conditional formatting & cell colour. | Excel Worksheet Functions | |||
Apply conditional formatting to individual cell Excel 2007 | Excel Worksheet Functions | |||
Cell shading with conditional formatting | Excel Discussion (Misc queries) | |||
Conditional Cell Shading (based on the shading of other cells) | Excel Worksheet Functions | |||
how do I use conditional formatting for alternating cell shading? | Excel Worksheet Functions |