| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
functions to change color of fonts or cell backgrounds?
Is there a way to use a function in a cell to reference another cell and also
make the other cell change colors in background or font. It would be like using conditional formatting but it would be controlled in a cell. It would look like this: =if (A10,A1 background is yellow, leave as is) Are there cell formula change color functions for background and fonts? Thank you |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
functions to change color of fonts or cell backgrounds?
Functions used in worksheets can only return a value to the cell in which
they are contained. With some very rare exceptions, they can not alter the excel environment. -- Regards, Tom Ogilvy "Yogi Smith" wrote: Is there a way to use a function in a cell to reference another cell and also make the other cell change colors in background or font. It would be like using conditional formatting but it would be controlled in a cell. It would look like this: =if (A10,A1 background is yellow, leave as is) Are there cell formula change color functions for background and fonts? Thank you |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can you change cell fonts using formula? | Excel Discussion (Misc queries) | |||
| change the default automatic color for gridlines and fonts | Setting up and Configuration of Excel | |||
| Excel: Syntax to change cell color based on color of another cell | Excel Worksheet Functions | |||
| funtions for colors for fonts or cell backgrounds? | Excel Worksheet Functions | |||
| Excel 2003 will not display color fonts or color fill cells | Excel Worksheet Functions | |||
Linear Mode
