+ Reply to Thread
Results 1 to 3 of 3

Apply two conditional formatting rules simultaneously

  1. #1
    Registered User
    Join Date
    09-02-2022
    Location
    Colombia
    MS-Off Ver
    365
    Posts
    5

    Apply two conditional formatting rules simultaneously

    Hi there. I am trying to apply two conditional formatting rules simultaneously but I am not getting the desired results.

    The rules are:

    Highlight with red if the column B is Empty and if column C is equal to ROSS AND Highlight with red if the column A is Empty and if column C is contains the string "Lois"

    And the fomula used in the formatting is:

    =OR(AND(ISBLANK*(B1);C1="ROSS");AND(ISBLANK*(A1);AND(COUNTIF(C1;"*Lois*"); "YES";"NO")="YES"))

    I am attaching a short Excel file.

    Thank you
    Attached Files Attached Files

  2. #2
    Forum Expert WideBoyDixon's Avatar
    Join Date
    10-03-2016
    Location
    Sheffield, UK
    MS-Off Ver
    365
    Posts
    2,182

    Re: Apply two conditional formatting rules simultaneously

    Change your A1, B1, and C1 references to A2, B2, and C2 in your formula since your conditional formatting doesn't start until C2.

    Please Login or Register  to view this content.
    WBD
    Office 365 on Windows 11, looking for rep!

  3. #3
    Registered User
    Join Date
    09-02-2022
    Location
    Colombia
    MS-Off Ver
    365
    Posts
    5

    Re: Apply two conditional formatting rules simultaneously

    Thank you, that was the solution. Highly appreciated.

+ 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: 4
    Last Post: 08-19-2018, 01:08 AM
  2. Match Multiple Cell Values and Apply Conditional Rules
    By Travis M. in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-10-2016, 11:47 AM
  3. Macro to select multiple pivot charts simultaneously and apply formatting
    By Reirvin in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-27-2015, 02:57 PM
  4. conditional formatting rules for a cell on sheet 1 based on rules from sheet 2
    By jsard in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 1
    Last Post: 08-15-2013, 09:22 AM
  5. Replies: 2
    Last Post: 06-01-2011, 06:59 PM
  6. Need to apply 4 conditional formatting rules.
    By eckert1961 in forum Excel Programming / VBA / Macros
    Replies: 21
    Last Post: 08-24-2008, 06:10 PM

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