Conditional format based on countifs

[KevinThomas]

Hi there, I am capable of creating CountIFS formula, but can;t get it to correlate to conditional formatting.

In Cell J2 i want the format to be yellow if countifs(J:J,J2,$B:$B,"X")>4 and countifs(K:K,K2,$B:$B,"X")>4

I can do the first bit, its placing the "and" part I am having issues with

Thanks in advance

[Colin Legg]

Hi,

Your profile says you are using XL 2003 but COUNTIFS() is only available in XL 2007 and later.

=AND(COUNTIFS(J:J,J2,$B:$B,"X")>4, COUNTIFS(K:K,K2,$B:$B,"X")>4)