Conditional Formatting with COUNTIF
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. |
Conditional Formatting with COUNTIF
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. |
Conditional Formatting with COUNTIF
=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. |
All times are GMT +1. The time now is 05:35 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com