| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Can I count cells with specific format (e.g., yellow field?)
I am trying to count cells that have a specific field color, such as green or
yellow. I'm scheduling emergency duty and need to make sure that the awful shifts (Friday nights and Saturday nights) get distributed evenly among the 30 interns/residents doing duty. I have the shift rows highlighted across the list of names to be schedules. I've used the COUNTIF function to count occurances of things, but it only accepts words, numbers, etc. as criteria. Any ideas? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| format cells | Excel Worksheet Functions | |||
| Count Rows with Conditional Format? | Excel Discussion (Misc queries) | |||
| Can I count how many grey-filled cells are in a row ? | Excel Worksheet Functions | |||
| Count non-colored cells | Excel Discussion (Misc queries) | |||
| Protected cells -automatically format to a different color | Excel Discussion (Misc queries) | |||
Threaded Mode
