Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Protect Cell Formatting including Conditional Formatting | Excel Discussion (Misc queries) | |||
Countif and conditional formatting | Excel Discussion (Misc queries) | |||
Conditional Formatting And Countif | Excel Discussion (Misc queries) | |||
Conditional countif | Excel Worksheet Functions | |||
Countif and Conditional Formatting | Excel Worksheet Functions |