Conditional Formatting Formula

[G00DNESS]

I'm in need of a conditional formatting formula so that when the (formula-driven, returned value) in Cell A27 minus the count of the formula-driven cells in Range C27:C50 that return "X" is greater than 5 the font color will equal red.

 

[Caribeiro77]

Maybe:
=A27-countif($C$27:$C$50,"x")>5

 

[G00DNESS]

Maybe:
=A27-countif($C$27:$C$50,"x")>5

Thanks for the response! That formula doesn't work.

 

[Caribeiro77]

What cells do you want to conditionaly format?
And if you put $ in A27 like so $A$27

 

[G00DNESS]

ADVERTISEMENT

What cells do you want to conditionally format?
And if you put $ in A27 like so $A$27

That didn't do the trick either. I am trying to conditionally format Cell A30.

 

[Caribeiro77]

Unless i'm miss interpretating what your asking....here's an example:

[/URL][/IMG]

 

[G00DNESS]

Unless i'm miss interpretating what your asking....here's an example:

[/URL][/IMG]

I solved the problem. I didn't want to do it this way, but what I ended up having to do was to 1) create a host cell (A51)containing the formula: =SUM(A27-COUNTIF(C27:C50,"X")), then 2) conditionally format Cell A30 to turn red if the host cell value was more than 5. I really didn't want to do that. Sigh!

 

[Caribeiro77]

Ok but if you choose cell A30 and then go to Conditional Formatting and put the formula i first gave you, that doesn't work?? Here i'm working exactly with the same ranges you are..

[/URL][/IMG]