Cell formatting from within a function

  • Thread starter Thread starter Unsichtbar
  • Start date Start date
U

Unsichtbar

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 CUBE>3 THEN ACTIVECELL.COLOR=RED_

END FUNCTION


I would appreciate any ideas on the subject.Thanks for your attentio
 
Hi Unsichtbar,
Is it possible to write a custom function which when executed in a cell
,automatically changes its formatting?
Click to expand...

Check out conditional formatting (Format, conditional format).

Regards,

Jan Karel Pieterse
Excel MVP
www.jkp-ads.com
 
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)
 
Back
Top