Hi,
you can use the formula:
=CELL("color",A1)

this would return a value 1, if cell font (only) is done with a color

like
#,##0_);[Red](#,##0) --- (negative numbers in red color and parenthesis)
;[Red]($#,##0.00); ---(negative numbers in red color and parenthesis)
[Green]#,##0_); ---(positive numbers in green color)

one point to note is that there should be one ;(semicolon) in the format

--
Please Click yes if this post was useful.

Kind Regards,
Satti Charvak
Only an Excel Enthusiast


"Paul" wrote:

Hey there,
is there any way in which logical test used in a formula could be, for
example,
"if(valueA=red text, value if true, value if false)"
or is there some other way in which the formatting of a value can influence
output
Sort of like the opposite of conditional formatting?

Any help would be appreciated,
Paul :)