|
|
|
|
#1
08-09-2012, 10:03 PM
|
||||
|
||||
Hi Matt,
See attached. I've used conditional formatting to apply one of three colours to the trigger cells - pale blue to for a value against a single trigger, yellow to indicate value against multiple triggers, red to indicate that a value should not be input against a given trigger (as there is already one for another portfolio).
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] 
|
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Conditional Formatting.
|
Laurie B. | Excel | 6 | 04-09-2012 05:01 PM |
| Conditional formatting | zanat0s | Excel | 4 | 01-20-2012 03:30 AM |
|
Conditional Formatting
|
namedujour | Excel | 3 | 08-25-2011 01:46 PM |
|
help with conditional formatting
|
Snvlsfoal | Excel | 3 | 07-03-2011 11:55 PM |
| Conditional Formatting to Hide Rows or Columns? | sczegus | Excel | 0 | 09-26-2006 04:17 PM |
Windows 7 64bit 
Office 2010 32bit
Hybrid Mode