|
|
|
|
#1
03-06-2014, 01:03 PM
|
||||
|
||||
Hi could you please post a sample sheet ? Thx
__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post 
|
|
#3
03-07-2014, 09:16 AM
|
|||
|
|||
|
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 |
Windows 7 64bit 
Office 2010 64bit
Hybrid Mode