+ Reply to Thread
Results 1 to 3 of 3

And Or Conditional Formula

  1. 02-25-2020, 07:47 AM #1
    lasc
    lasc is offline
    Registered User
    Join Date
    08-13-2019
    Location
    Louisiana
    MS-Off Ver
    excel
    Posts
    50

    And Or Conditional Formula

    What is the conditional formula for this set of criteria:

    If Cell A1 = X and Cell B1 = W or Y or Z, then format cell
    Reply With QuoteRegister To Reply
  2. 02-25-2020, 07:57 AM #2
    KOKOSEK
    KOKOSEK is offline
    Forum Expert KOKOSEK's Avatar
    Join Date
    08-03-2018
    Location
    Pole in Yorkshire, UK
    MS-Off Ver
    365/2013
    Posts
    2,742

    Re: And Or Conditional Formula

    Formula: copy to clipboard 
    Please Login or Register  to view this content.
    Happy with my answer * Add Reputation.
    If You are happy with solution, please use Thread tools and mark thread as SOLVED.
    Reply With QuoteRegister To Reply
  3. 02-25-2020, 10:47 AM #3
    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,447

    Re: And Or Conditional Formula

    @lasc

    Administrative note
    Please update your profile as necessary to properly reflect the exact version(s) of Excel your question relates to. Members tailor answers based on your Excel version. Your profile does not indicate your version.
    Thanks
    How to paste Power Query code ( by Olly)
    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)

Similar Threads

  1. Conditional Formatting formula does not work even though formula is returing correctly
    By random11 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-05-2020, 07:23 PM
  2. [SOLVED] VBA to create a relative formula in a conditional format (rather than an absolute formula)
    By The_Snook in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-07-2016, 08:00 AM
  3. [SOLVED] Conditional Statement for Negative Numbers inside a Conditional Formula
    By kuzniak in forum Excel Formulas & Functions
    Replies: 18
    Last Post: 12-18-2015, 11:17 PM
  4. formula help - conditional format to colour cell = count = formula
    By rangeruk in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-23-2015, 09:03 PM
  5. Conditional formatting formula issues (dynamically changing the sheet name in the formula)
    By nebmot in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-28-2013, 02:11 AM
  6. Changing conditional average formula to conditional sumproduct
    By chlor in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-29-2007, 11:39 AM
  7. [SOLVED] How do I do a complex conditional in a conditional formatting formula
    By Ray Stevens in forum Excel General
    Replies: 6
    Last Post: 03-12-2006, 06:30 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1