Thread: Need formula for search and conditional formatting
View Single Post
 
Old 01-13-2012, 08:57 AM
MikeJedi MikeJedi is offline Windows XP Office 2003
Novice
  
Join Date: Dec 2009
Posts: 6
MikeJedi is on a distinguished road
Default
Quote:
Originally Posted by Pecoflyer View Post
OK Mike, first things first - see attached for the named ranges ( CF will not work on different sheets any other way)
So you will have to do the same on your data ( names can be anything just avoid XL terms like sheet, workbook, column,etc..)
Ok, I have named my ranges on the first sheet (used the same that you did).

Now what?
Reply With Quote