![]() |
|
|
|
#1
|
|||
|
|||
|
Please see attached spreadsheet with notations. Thanks in advance for your help.
|
|
#2
|
|||
|
|||
|
I was able to solve my problem. See the attached spreadsheet. Go to the tab 'Problem Solved'.
The first part was accomplished by simply using the "Use Formula" option in the Conditional Formatting function. The second part was accomplished by setting up a Named Range and then testing against that in the Conditional Formatting "Use Formula" function. Thanks to anyone who was working on this for me. Steve |
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Conditional formatting value change of same cell | tcalhoun | Excel | 0 | 04-25-2013 07:25 AM |
Conditional formatting question based on cell date
|
Cosmo | Excel | 2 | 04-08-2013 12:12 PM |
| Conditional Formatting Expiration Dates Based on Text in Adjacent Cell | Frogggg | Excel | 1 | 10-25-2011 08:44 PM |
| How can I fill cell color starting from Cell D5 using Conditional formatting instead | Learner7 | Excel | 0 | 07-08-2010 05:50 AM |
Conditional formatting of cell, Excel 2003
|
Scaffold | Excel | 2 | 05-01-2010 08:56 AM |