+ Reply to Thread
Results 1 to 4 of 4

Conditional Formatting on SORT(UNIQUE( cells

  1. #1
    Registered User
    Join Date
    08-17-2016
    Location
    Australia
    MS-Off Ver
    Office 365 Business
    Posts
    90

    Conditional Formatting on SORT(UNIQUE( cells

    I have the following formula in A3, which obviously populates A4 to B23
    =IFERROR(SORT(UNIQUE(FILTER(Bookings!$A$2:$B$1000,$A$1=Bookings!$H$2:$H$1000))),0)

    Column C, has a dropdown choice of blank or 'Move'

    What I want to achieve via Conditional Formatting is a strikethrough of the data in Columns A & B, where 'Move' has been chosen in Column C

    I have the following formula '=C4="Move"' to to '=$A$4:$B$23'

    This works on the data in Column A, but not Column B.

    Any suggestions?
    Attached Files Attached Files
    Last edited by MattKoleczko; 02-15-2024 at 01:07 AM.

  2. #2
    Valued Forum Contributor
    Join Date
    10-17-2007
    Location
    Tasmania, Australia
    MS-Off Ver
    2019, 365(v2310)
    Posts
    366

    Re: Conditional Formatting on SORT(UNIQUE( cells

    Do you have a sample file to upload.

  3. #3
    Forum Guru HansDouwe's Avatar
    Join Date
    06-21-2022
    Location
    Nederland
    MS-Off Ver
    365 V2403 (Build 17330.20000)
    Posts
    6,459

    Re: Conditional Formatting on SORT(UNIQUE( cells

    Please add a $ sign to the CF-rule:
    Formula: copy to clipboard
    Please Login or Register  to view this content.

  4. #4
    Registered User
    Join Date
    08-17-2016
    Location
    Australia
    MS-Off Ver
    Office 365 Business
    Posts
    90

    Re: Conditional Formatting on SORT(UNIQUE( cells

    Genius. Also, I'm an idiot.

+ 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: 09-12-2021, 10:12 AM
  2. Conditional formatting....sort of.
    By scudo in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-25-2015, 01:40 PM
  3. [SOLVED] Conditional formatting and sort
    By Nigel in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 04-08-2015, 12:01 AM
  4. Conditional Formatting for Unique IDs in Columns
    By mycon73 in forum Outlook Formatting & Functions
    Replies: 2
    Last Post: 08-24-2011, 05:45 PM
  5. Excel 2007 : Unique Conditional Formatting...
    By Trakx in forum Excel General
    Replies: 6
    Last Post: 04-20-2011, 03:10 PM
  6. Conditional Formatting - search for unique value in different Row
    By mgh234 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-13-2010, 10:17 AM
  7. Sort conditional formatting
    By meridklt in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-18-2007, 04:38 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