| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Colour Formular (Not a function!)
Hi again,
Is it possible to have a formular that takes the colour from one cel and uses it to for the text colour in the cell with this formular? I require this as I have 4 cells. 1 for some text, 1 for the backgroun colour, 1 for the text colour and 1 for a sample of what the text wil look like with the colours set in the other 2 cells. I know how to do this as a function but really want it as a cel formular! Any ideas? Cheer -- Message posted from http://www.ExcelForum.com |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Colour Formular (Not a function!)
|
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Colour Formular (Not a function!)
If you mean you put the formula in a worksheet, then functions are not
allowed to change the excel environment - so this is not possible. They can only return a value to the cell in which they are used. -- Regards, Tom Ogilvy "grovesy " wrote in message ... Anyone? --- Message posted from http://www.ExcelForum.com/ |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I specify text colour in an Excel function | Excel Discussion (Misc queries) | |||
| Formular Function | Excel Worksheet Functions | |||
| is there any automatic colour change function? | Excel Worksheet Functions | |||
| i want to use the =if function to apply a colour to other cells | Excel Worksheet Functions | |||
| No showing of cellnumbers used in formular with colour | Excel Worksheet Functions | |||
![grovesy[_4_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
