Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cell formatting from within a function
Is it possible to write a custom function which when executed in a cel
,automatically changes its formatting? Ideally this would look something like this: FUNCTION CUBE(X) AS DOUBLE CUBE=X^3 (PSEUDO-CODE --) IF CUBE3 THEN ACTIVECELL.COLOR=RED_ END FUNCTION I would appreciate any ideas on the subject.Thanks for your attentio -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cell formatting from within a function
Hi Unsichtbar,
Is it possible to write a custom function which when executed in a cell ,automatically changes its formatting? Check out conditional formatting (Format, conditional format). Regards, Jan Karel Pieterse Excel MVP www.jkp-ads.com |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cell formatting from within a function
With Conditional Formatting you can change some Font attributes (colour,
style), borders and cell colour, but that's all. Check it out in help. -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "Unsichtbar " wrote in message ... Is it possible to write a custom function which when executed in a cell ,automatically changes its formatting? Ideally this would look something like this: FUNCTION CUBE(X) AS DOUBLE CUBE=X^3 (PSEUDO-CODE --) IF CUBE3 THEN ACTIVECELL.COLOR=RED_ END FUNCTION I would appreciate any ideas on the subject.Thanks for your attention --- Message posted from http://www.ExcelForum.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cell Formatting by function | Excel Worksheet Functions | |||
function formatting a cell | Excel Discussion (Misc queries) | |||
formatting a cell with a function (IF statement) | Excel Worksheet Functions | |||
Formatting a cell with a function (IF statement) | Excel Worksheet Functions | |||
Changing cell formatting with IF function | Excel Worksheet Functions |