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.
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!