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, 11:06 AM #12
    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

    On January Sheet, select the range B32:AF39 and use the following formula for conditional formatting.

    For Green
    =LEFT(B32,2)="S1"
    For Blue
    =LEFT(B32,2)="S2"
    See the attached sheet with conditional formatting applied.
    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] 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