| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Apply color of one cell to other
Hello,
How can I apply the color settings of one cell to another through a formula? Ex- If cell A1 is filled with red color, I want cell B1 to be filled with red color too based on the formula. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Apply color of one cell to other
hi
to answer your question....no, not through a fomula. formulas return value to the cell in which they reside. they cannot perform actions such as change formating, put values in other cells, copy, paste, etc. but you might be able to perform what you want with conditionsal fomating. post your formula and other conditions and i (or someone) might be able to at least point you in the right direction. regards FSt1 "Tigerxxx" wrote: Hello, How can I apply the color settings of one cell to another through a formula? Ex- If cell A1 is filled with red color, I want cell B1 to be filled with red color too based on the formula. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Apply color of one cell to other
Not with a formula.
It would have to be VBA: http://www.cpearson.com/excel/colors.aspx http://xldynamic.com/source/xld.ColourCounter.html http://www.ozgrid.com/VBA/Sum.htm -- David Biddulph Tigerxxx wrote: Hello, How can I apply the color settings of one cell to another through a formula? Ex- If cell A1 is filled with red color, I want cell B1 to be filled with red color too based on the formula. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Apply color of one cell to other
Thanks guys...I just wish Microsoft comes up with a simpler way!
"David Biddulph" wrote: Not with a formula. It would have to be VBA: http://www.cpearson.com/excel/colors.aspx http://xldynamic.com/source/xld.ColourCounter.html http://www.ozgrid.com/VBA/Sum.htm -- David Biddulph Tigerxxx wrote: Hello, How can I apply the color settings of one cell to another through a formula? Ex- If cell A1 is filled with red color, I want cell B1 to be filled with red color too based on the formula. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How many conditions can I apply to a cell? I need to apply 8. | Excel Discussion (Misc queries) | |||
| How to apply different color on different columns and legends easily? | Charts and Charting in Excel | |||
| Excel: Syntax to change cell color based on color of another cell | Excel Worksheet Functions | |||
| HOW CAN I APPLY A COLOR TO ENTIRE ROW USING CONDITIONAL FORMATT | Excel Worksheet Functions | |||
| How do I apply color in cells ..color now shown only in print prev | Excel Worksheet Functions | |||
Linear Mode
