Excel 2007 : I am trying to create a formula using color of text in cell.. so if cell text is red

I am trying to create a formula that can red the text color from another cell....so =if (e4cell red),then "e12-100") Can something like this be done?

It can be either the cell text color or I can fill the necessary with color

There isn't a standard formula to read a cell's text colour, but you can write a user-defined function to do so:

Please Login or Register  to view this content.

One issue with this is that changing a cell's text colour does not trigger a recalculation, so even if the function is volatile you'll still have to press F9 to do a sheet recalculation every time a cell's colour changes, or the result from the formula won't update.