Changing a cell color...

27/10/2003 - 21:17 por Shaul | Informe spam
Hi,
Can someone help me how can I chane a cell color using the"IF" command???
Thank you,
Shaul
 

Leer las respuestas

#1 Héctor Miguel
28/10/2003 - 02:48 | Informe spam
Hi, Shaul !

Can someone help me how can I change a cell color using the"IF" command???



depending of what the 'if command' meaning is:
-o- if worksheet function, the answer [I'm afraid) is: NO!
[unless you define a custom number format / style, or apply format conditions]
-o- if vba function through macro code, you need to use the .Font.ColorIndex property of a range object
[maybe handling events in worksheet code-module]
which are the conditions / requirements for color change?

Regards,
Héctor.

P.S. you might want to try posting in the english newsgroups:
microsoft.public.excel.worksheet.functions
microsoft.public.excel.programming
microsoft.public.excel.misc
microsoft.public.excel

Preguntas similares