If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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. |
Thread Tools | |
Display Modes | |
|
|