I would like to have cell A11 set to show red via conditional formatting if
the cells F11:J11 and AI11:BF11 have either a number, date or text in them,
but excluding cells that contain X and the total is less than 12.
This is the formulae I have been trying;
=(COUNTIF(F11:J11,"<"&X)+COUNTIF(AI11:BF11,"<"&X ))<12

Similarly A11 should go yellow if the total is between 12 and 25.

Any suggestions.

Try this:
first condition for red:
=COUNTA(F11:J11,AI11:BF11)-COUNTIF(F11:J11,"<"&"X")-COUNTIF(AI11:BF11,"<"&"X")<12
second condition for yellow:
=COUNTA(F11:J11,AI11:BF11)-COUNTIF(F11:J11,"<"&"X")-COUNTIF(AI11:BF11,"<"&"X")<25


Regards,
Stefi


€žRovermog€� ezt Ã*rta:

I would like to have cell A11 set to show red via conditional formatting if
the cells F11:J11 and AI11:BF11 have either a number, date or text in them,
but excluding cells that contain X and the total is less than 12.
This is the formulae I have been trying;
=(COUNTIF(F11:J11,"<"&X)+COUNTIF(AI11:BF11,"<"&X ))<12

Similarly A11 should go yellow if the total is between 12 and 25.

Any suggestions.

=AND(COUNTIF(F11:J11,"<X")+COUNTIF(AI11:BF11,"<X ")-COUNTBLANK(F11:J11)-COUNTBLANK(AI11:BF11)=12,
COUNTIF(F11:J11,"<X")+COUNTIF(AI11:BF11,"<X")-COUNTBLANK(F11:J11)-COUNTBLANK(AI11:BF11)<=15)

--
__________________________________
HTH

Bob

"Rovermog" wrote in message
...
I would like to have cell A11 set to show red via conditional formatting if
the cells F11:J11 and AI11:BF11 have either a number, date or text in
them,
but excluding cells that contain X and the total is less than 12.
This is the formulae I have been trying;
=(COUNTIF(F11:J11,"<"&X)+COUNTIF(AI11:BF11,"<"&X ))<12

Similarly A11 should go yellow if the total is between 12 and 25.

Any suggestions.