Cell Formula That Evaluates The Formatting Of Another Cell?

[CaliKidd]

Assume cell A1 has a conditional format rule that changes the font color to red if the value is negative. Otherwise, it leaves the font color black.

Is it possible to put a formula in a different cell that determines if the font color of cell A1 is red and, if so, returns a True, else returns a False? What would that Excel formula be?

 

[Andrew Poulsom]

Why not?

=A1<0

 

[CaliKidd]

Well, my main intent is to see if a formula can detect the formatting of a different cell. It's not the value I am trying to test, but rather the cell format.

 

[Andrew Poulsom]

Not without VBA.

 

[Weaver]

And then you'd need to parse the format conditions. I've seen it done, but it was some serious code.

There's a script I once saw poseted on this forum somewhere that converts condtional formatting to static formatting - I'd imagine there would be some clues in there to help you achieve what you're after.

 

[CaliKidd]

VBA is ok, if that is what it takes.

I am hoping it could be a formula so that if the value of cell A1 was changed to a non-negative number, which would then cause the conditional format rule to change the font color back to black, rhen the formula would evaluate real-time (i.e., return a False value).

I hope I am being clear.

Any ideas how to do this?

 

[Andrew Poulsom]

The easiest way is to use the conditional formatting formula as I suggested previously.