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?
Bookmarks