+ Reply to Thread
Results 1 to 6 of 6

Conditional Formatting Challenge

  1. #1
    Forum Contributor
    Join Date
    05-29-2017
    Location
    UK
    MS-Off Ver
    Pro Plus 2016
    Posts
    301

    Conditional Formatting Challenge

    hi guys, cant seem to get my head around this formating thing.

    a) GZ11:GZ25 contains text

    b) look KC11:KC25 and if found duplicating text, highlight it in red

    I currently have =GZ11=$KC$11:$KC$25 applied on GZ11:GZ25, does not work... why is that? what is a correct formula pls?

    Thanking in advance!

    https://www.excelforum.com/attachmen...1&d=1623590185
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,028

    Re: Conditional Formatting Challenge

    How about
    Formula: copy to clipboard
    Please Login or Register  to view this content.

  3. #3
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,090

    Re: Conditional Formatting Challenge

    Maybe try the formula:
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  4. #4
    Forum Contributor
    Join Date
    05-29-2017
    Location
    UK
    MS-Off Ver
    Pro Plus 2016
    Posts
    301

    Re: Conditional Formatting Challenge

    that worked, thank you guys!!!

  5. #5
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,028

    Re: Conditional Formatting Challenge

    You're welcome & thanks for the feedback.

  6. #6
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,090

    Re: Conditional Formatting Challenge

    You're welcome. Thanks for the rep.

+ 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. Nested conditional formatting challenge
    By TheHolyLemon in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-01-2018, 03:57 PM
  2. Conditional formatting challenge
    By dalestock2 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-15-2017, 12:02 AM
  3. A Real Challenge (Chart formatting) for charity!
    By mj54 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 07-09-2014, 05:22 AM
  4. [SOLVED] Calendar challenge conditional formatting colour
    By tis1337 in forum Excel General
    Replies: 2
    Last Post: 11-11-2012, 01:07 PM
  5. [SOLVED] Conditional Formatting and Vailidation Challenge
    By haleakala17 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-02-2012, 02:56 AM
  6. Conditional formating challenge
    By mikeb1969 in forum Excel General
    Replies: 2
    Last Post: 02-10-2010, 12:24 PM
  7. [SOLVED] conditional formatting challenge
    By brendan in forum Excel General
    Replies: 2
    Last Post: 10-18-2005, 04:05 AM

Tags for this Thread

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