Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Color coding cells
Is it possible to format cell A1 to display the same color as the color
hi-lighted in cell A14? There is no text in cell A14, only a color. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Color coding cells
Use the format painter (looks like a little yellow paint brush) icon on your
toolbar. If you don't have it, add -- Don Guillett Microsoft MVP Excel SalesAid Software "JayDee" wrote in message ... Is it possible to format cell A1 to display the same color as the color hi-lighted in cell A14? There is no text in cell A14, only a color. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Color coding cells
No, a formula will not do that. If the color in A14 is driven by some
condition in the file or sheet, you may be able to use Conditional Formatting in cell A1 to get that color, otherwise you will have to use VBA. Post back with more info. HTH Otto "JayDee" wrote in message ... Is it possible to format cell A1 to display the same color as the color hi-lighted in cell A14? There is no text in cell A14, only a color. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
color coding | Excel Discussion (Misc queries) | |||
Color coding cells | Excel Discussion (Misc queries) | |||
Color Coding Cells | Excel Worksheet Functions | |||
color coding | Excel Worksheet Functions | |||
Color coding cells in Excel | Excel Discussion (Misc queries) |