Results 1 to 10 of 10

Conditional Format based on multiple criteria

Threaded View

  1. #8
    Forum Expert NBVC's Avatar
    Join Date
    12-06-2006
    Location
    Mississauga, CANADA
    MS-Off Ver
    2003:2010
    Posts
    34,898

    Re: Conditional Format based on multiple criteria

    Scratch that...

    Do the first part with rows 2 to bottom selected and apply the formatting...

    Then select rows 3 down and paste the same formula in:

    i.e. use: =AND($A2<>"",$F2=$F3,$G2=$G3,$H2=$H3,$L2=$K3) for rows 2 down and then again for rows 3 down
    Last edited by NBVC; 02-16-2010 at 10:15 PM. Reason: noticed a colon where a equal sign should be

Thread Information

Users Browsing this Thread

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

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