Check text color in an IF statement

[azo]

What I need to do is check to see if a cell has a certain text color then provide me a true statement.

In B2: =IF(A2=Text Color Red, "Text 1")

Is that even possible in excel 2007?

Azo

 

[Akashwani]

Hi Azo,

I don't write or understand VBA, so I am unable to help you further with code, sorry.

Do you mean something like this?.....

Excel Workbook
	A	B	C
1	Data	Font Colour	Formula
2	MrExcel	1	Not Red Font
3	Test	3	Text 1
4	Akashwani	23	Not Red Font
5	Grass	14	Not Red Font
Sheet5

Press alt F11.
Click on Insert - Module
Paste this code into the white area....

Function txtColor(rng As Range)
txtColor = rng.Font.ColorIndex
End Function

Press alt F11.

You can now use this in your IF formula.....

txtColor(A2)=3

The formulas in B2:C2 in the sample data above need to be copied down.

I hope that works for you.

Good luck.

Ak

 

[Icarossw]

Hi!

I have tested the suggested solution above and it works beautiful, but!
To update the cells I need to edit and press enter on each one of the, how do I do an update of all of the cell in one stroke?

Reg
Joakim