+ Reply to Thread
Results 1 to 2 of 2

Conditional formatting based on multiple criteria

  1. 07-07-2009, 08:11 AM #1
    mainemojo
    mainemojo is offline
    Forum Contributor
    Join Date
    07-01-2009
    Location
    Maine, USA
    MS-Off Ver
    Excel 2016
    Posts
    161

    Conditional formatting based on multiple criteria

    I have four columns for this purpose:

    ColB - PLastName
    ColC - PFirstName
    ColM - ULastName
    ColN - UFirstName

    If ColB and ColC match ColM and ColN (Should match the values for MatchRow), I would like to use VBA to conditionally format the entire row with a yellow background.

    Also, any cell in the selection with an error, I want to format the entire row with a red background.

    Please Login or Register  to view this content.
    Last edited by mainemojo; 07-07-2009 at 10:04 AM. Reason: Added some more criteria
    Reply With QuoteRegister To Reply
  2. 07-09-2009, 09:33 PM #2
    venkat1926
    venkat1926 is offline
    Valued Forum Contributor
    Join Date
    06-17-2009
    Location
    Chennai,India
    MS-Off Ver
    Excel 2003,excel 2007
    Posts
    678

    Re: Conditional formatting based on multiple criteria

    this macro is only for coloring the rows.

    try this macro and modify if necessary. post feedback
    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1