IF Formula to test textcolor

Hi all,

Whats the formula for testing if textcolor is red or black in another cell?

I've tried something like IF(A16;ColorIndex=3;.....so on, but I need help to get it work.

Thanks in advance

//Thomas

If you formatted the cell as a number and picked the red as the way to show negative, the following should help. If you just formatted the font as red for the cell this doesn't seem to work and not sure of how to get it (other than creating a function using visual basic).


=CELL("color",C4)

Hi,

To explain some more:

in cell D1: IF(B1=textcolor black then formula in G1;IF(B1=textcolor red then formula in H1)

I'm not even sure that there is a way to test it in a formula.....
I dont want to do this in code.


Any idea's, anyone?