| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Having troubles with conditional formatting
FOM DEC JAN
Rich G james-8 Mark Hamm Korry-11 Mark Hamm Chris-21 Dave-2, Matt-22,Chris 23 Mark Hamm Korry-26 Rich G Steve-20 Mark Hamm Matt-11 Matt-22 Mark Hamm Korry-3 Matt K Mark Hamm Chris-25 Mark Hamm Korry-11 Rich G James-8 Mark Hamm Mark Hamm Rich G Mark Hamm Chris O - 22 Mark Hamm Matt K John K-16 Mark Hamm matt-7 Mark Hamm Korry-16 Mark Hamm Matt-11 Mark Hamm Ok so here is what im trying to do, for example there are 4 rows that have Rich G as FOM in those 4 rows there was 3 monthly checks done in DEC so at the bottom of that column it would show 3, and for Jan it would show 0, I am having trouble trying to write a formula that filters the month columns by a FOM that counts how many rows have non blank cells if that row matches a certain FOM. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| COM Add-in Troubles | Excel Discussion (Misc queries) | |||
| conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
| conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
| IF troubles | Excel Worksheet Functions | |||
| Conditional Formatting that will display conditional data | Excel Worksheet Functions | |||
Threaded Mode
