View Single Post
 
Old 03-07-2014, 09:16 AM
SteveBump SteveBump is offline Windows 7 64bit Office 2010 64bit
Novice
 
Join Date: Oct 2013
Posts: 24
SteveBump is on a distinguished road
Default

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
Attached Files
File Type: xlsx Conditional Formatting Example.xlsx (16.1 KB, 14 views)
Reply With Quote