How to do a function that alters the format of the cell when it is applied?

  • Thread starter Thread starter faustino Dina
  • Start date Start date
F

faustino Dina

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

Functions cannot alter formats, only return results to the cell they are in.

Try......Format>Conditional Formatting>Cell Value is: less than 0

FormatPatterns>select color then OK your way out.

Gord Dibben Excel MVP
 
Back
Top