+ Reply to Thread
Results 1 to 5 of 5

Conditional Formatting + Name Ranges

  1. #1
    Registered User
    Join Date
    09-17-2013
    Location
    Edmonton
    MS-Off Ver
    Excel 2007
    Posts
    47

    Conditional Formatting + Name Ranges

    Hey Everyone,

    I have another conditional formating challenge. I'm trying to get it so that every second cell from W4, turns white if C4 (and every second cell after that, C6, C8, etc) equal/match something in the name range "P.Ten" To solve the "Every Second Cell" i've been using =AND(MOD(ROW(),2)=0,_________ )) But I just dont know what to use to search in a name range. See Attached Sample.

    sample.xlsm

  2. #2
    Registered User
    Join Date
    09-17-2013
    Location
    Edmonton
    MS-Off Ver
    Excel 2007
    Posts
    47

    Re: Conditional Formatting + Name Ranges

    Bump bump bump

  3. #3
    Registered User
    Join Date
    09-17-2013
    Location
    Edmonton
    MS-Off Ver
    Excel 2007
    Posts
    47

    Re: Conditional Formatting + Name Ranges

    Try again.... anyone?

  4. #4
    Forum Expert
    Join Date
    09-20-2011
    Location
    England
    MS-Off Ver
    Excel 2010
    Posts
    2,278

    Re: Conditional Formatting + Name Ranges

    Hello
    Initially I'd come up with the following CF formula:

    Please Login or Register  to view this content.
    However, I'm not sure how this fits in with your example file as the Vlookup in C4 looks for airline names which are not in the P.ten range.

    DBY
    Last edited by DBY; 10-21-2013 at 02:17 PM. Reason: amended reply

  5. #5
    Registered User
    Join Date
    09-17-2013
    Location
    Edmonton
    MS-Off Ver
    Excel 2007
    Posts
    47

    Re: Conditional Formatting + Name Ranges

    DBY.... thats money!!! it works great, thank you!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 3
    Last Post: 05-15-2012, 04:13 PM
  2. [SOLVED] Conditional Formatting with Named Ranges
    By Revverend in forum Excel General
    Replies: 7
    Last Post: 04-02-2012, 05:31 AM
  3. Conditional Formatting for two ranges
    By Peter-B in forum Excel General
    Replies: 2
    Last Post: 10-07-2011, 06:53 AM
  4. Conditional Formatting Date Ranges
    By Justinmih in forum Excel General
    Replies: 2
    Last Post: 11-05-2010, 08:34 PM
  5. Conditional Formatting to get top counts in ranges
    By Dynamo418 in forum Excel General
    Replies: 21
    Last Post: 06-30-2010, 04:58 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1