|
|
|
|
#1
03-13-2014, 10:58 AM
|
|||
|
|||
Here I've made a sample possible solution (though it's not exactly what you want).
There is a data table with [Facility] and [Entered]. Then there is a tally table that lists all the facilities and the number of responses they each have for any particular date. If the count is less than 3, it is highlighted. 
|
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Header must toggle text & color + show count of conditionally formatted cells below | Franktoon | Excel | 3 | 02-18-2014 02:10 PM |
 Conditionally Email People Based on Values in Fields
|
dawsonh2002 | Mail Merge | 2 | 12-12-2012 12:11 PM |
| How to merge two columns & replace contents of cells conditionally? | mag | Excel | 3 | 10-24-2012 01:07 PM |
|
Macro to conditionally delete rows
|
Steve_D | Excel | 2 | 08-24-2012 09:37 PM |
| Macro to conditionally create or go to worksheet | Reinaldo123 | Excel Programming | 1 | 07-06-2012 07:23 AM |
Windows 7 64bit 
Office 2010 64bit
Hybrid Mode