+ Reply to Thread
Results 1 to 6 of 6

Compare Colums and Color enire row if values (text) do not match

  1. 02-27-2013, 09:28 AM #1
    GatorsBucs
    GatorsBucs is offline
    Registered User
    Join Date
    02-08-2013
    Location
    St Petersburg, FL
    MS-Off Ver
    Excel 2010
    Posts
    19

    Compare Colums and Color enire row if values (text) do not match

    Hello,
    I have a work sheet that I would like to compare the values (text) in colums H and R. If they do not match color the entire row.

    Thanks!
    Reply With QuoteRegister To Reply
  2. 02-27-2013, 09:29 AM #2
    Pepe Le Mokko
    Pepe Le Mokko is offline
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,453

    Re: Compare Colums and Color enire row if values (text) do not match

    VBA or CF solution ?
    How to paste Power Query code ( by Olly)
    Reply With QuoteRegister To Reply
  3. 02-27-2013, 09:31 AM #3
    GatorsBucs
    GatorsBucs is offline
    Registered User
    Join Date
    02-08-2013
    Location
    St Petersburg, FL
    MS-Off Ver
    Excel 2010
    Posts
    19

    Re: Compare Colums and Color enire row if values (text) do not match

    VBA please
    Reply With QuoteRegister To Reply
  4. 02-27-2013, 11:02 AM #4
    JOHN H. DAVIS
    JOHN H. DAVIS is offline
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: Compare Colums and Color enire row if values (text) do not match

    Maybe:

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  5. 02-27-2013, 11:24 AM #5
    GatorsBucs
    GatorsBucs is offline
    Registered User
    Join Date
    02-08-2013
    Location
    St Petersburg, FL
    MS-Off Ver
    Excel 2010
    Posts
    19

    Re: Compare Colums and Color enire row if values (text) do not match

    Perfect1 Thanks!
    Reply With QuoteRegister To Reply
  6. 02-27-2013, 11:43 AM #6
    JOHN H. DAVIS
    JOHN H. DAVIS is offline
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: Compare Colums and Color enire row if values (text) do not match

    You're welcome. Glad I could help and thanks for the feedback.
    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