Creating Formulas Based On Cell Colors From Conditional Formatting

[daburkesjp]

Hello,

I was wondering if anyone knows how to create a formula that is dependent on the colors of a range of cells subject to conditional formatting. For example, I would like something that could answer =if(A1 is red,"Phillies",if(A1 is blue,"Mets","Marlins)). However, the text color will be generated from conditional formatting, so most of the VBA code I have found thus far isn't working properly. Does anyone know of a solution? Thanks in advance.
<!-- / message --><!-- sig -->

 

[Jonmo1]

Welcome to the board...

You would probably be better off counting the conditions that created the conditional format...

for example, if the conditional format formula in column A is
=A1="Hello", therby coloring any cells in column A if it's value is "Hello"

You would use a formula to count how many cells = "Hello", not how many are colored...

=countif(A:A,"Hello")

Hope that helps..