Results 1 to 6 of 6

IF NOT with multiple conditions

Threaded View

  1. 10-23-2023, 04:07 PM #1
    trosasco23
    trosasco23 is offline
    Forum Contributor
    Join Date
    06-27-2014
    Location
    Margate, FL
    MS-Off Ver
    MS Office 2016
    Posts
    222

    IF NOT with multiple conditions

    Hello, I'm working on a formula to catch errors in my excel report. I needed a conditional formatting to highlight anything that is not either of the codes listed in column R (as shown below). if anyone enters anything other than these below, I want to highlight the fill RED.

    Please see attached.

    01.3000.00 > TLAD
    01.3000.00 > LS
    01.3000.00 > LR
    01.3000.00 > VACA
    01.3000.00 > TLOE
    01.3000.00 > SICK
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
« 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. [SOLVED] Help for IF conditions with multiple Conditions (scenario more than 5 conditions)
    By meily_o26 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 12-16-2019, 02:13 AM
  2. transfer of specific data Based On Multiple Conditions from worksheet to Multiple sheets
    By salmasaied in forum Excel Programming / VBA / Macros
    Replies: 29
    Last Post: 01-01-2017, 10:25 AM
  3. Retrieve data from table - multiple conditions / conditions within conditions
    By weedtm in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-14-2016, 03:53 PM
  4. [SOLVED] Vlookup - Country conditions (Multiple conditions)
    By dluhut in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 04-26-2013, 11:42 AM
  5. Insert multiple values from seperate table based on multiple conditions
    By drakesong in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 02-28-2011, 06:04 PM
  6. Write to multiple text files from multiple Excel worksheets based on some conditions
    By E-tech in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-05-2010, 04:39 AM
  7. How to multiple conditions to validate more than 2 conditions to .
    By Bhuvana Govind in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-28-2005, 04:06 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1