Results 1 to 18 of 18

right formula to include it in conditional format when I need to include many criterias

Threaded View

  1. 08-26-2014, 06:55 AM #6
    sktneer
    sktneer is offline
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,655

    Re: right formula to include it in conditional format when I need to include many criteria

    Make New Rules for conditional formatting using the below formulas.....

    For Green
    =LEFT(B1,2)="S1"
    For Blue
    =LEFT(B1,2)="S2"
    Is this what you are trying to achieve?
    Attached Files Attached Files
    Regards
    sktneer

    Treat people the way you want to be treated. Talk to people the way you want to be talked to.
    Respect is earned NOT given.
    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] Editing a Macro to include multiple rows and include text formatting for leading zeros
    By missmea2005 in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 04-04-2014, 09:50 AM
  2. [SOLVED] How to create a formula/format for a long number to include a period and not round
    By Rita Bush in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 12-13-2013, 01:13 PM
  3. To Include or Not Include Holidays When Forecasting
    By mycon73 in forum Excel General
    Replies: 7
    Last Post: 11-03-2013, 04:09 PM
  4. conditional formula, if date entered, include in totals
    By arbert in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-24-2012, 09:29 PM
  5. Conditional Formula for time window to include a buffer zone
    By sonny.thind in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 08-23-2011, 12:27 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