View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
faustino Dina[_2_] faustino Dina[_2_] is offline
external usenet poster
 
Posts: 2
Default How to do a function that alters the format of the cell when it is applied?

Hi,

I need to do a function that alters the format of the cell in which it is
applied. For example, suppose it is a function f() that returns a number. I
need if this number is < 0 the result in the cell will be displayed red,
else in black. How can I do that?
Any idea is welcomed

Thanks in advance

--
Faustino Dina
--------------------------------------------------------
If my email address starts with two 'f'
drop the first 'f' when mailing me.