+ Reply to Thread
Results 1 to 2 of 2

Conditional Formatting with IF and AND Statements

  1. #1
    Registered User
    Join Date
    03-02-2011
    Location
    london
    MS-Off Ver
    Excel 2003
    Posts
    29

    Conditional Formatting with IF and AND Statements

    Hiya,

    I need to apply conditional formatting where the user can select the following from column P ( this is a validated list)

    Minor Void Works (10 days)
    Major Void Works (20 Days)
    Long Term Void Works
    Disposal
    Management Void
    Options Appraisal

    I need to apply the conditional formatting base in the number of days in column AH and colour it in. Each selection will have different colours.

    If Minor Void Works (10 days) is selected and AH cell is under 10 days then its green, otherwise RED
    If Major Void Works (20 days) is selected and AH cell is under 20 days then its green, otherwise RED
    and all others will be orange if over 20 days and red if over 50 days.

    Hope this makes sence.

  2. #2
    Forum Contributor vamosj's Avatar
    Join Date
    04-23-2004
    Location
    Oregon
    MS-Off Ver
    2010
    Posts
    294

    Re: Conditional Formatting with IF and AND Statements

    To better assist you, please attach a clean (no personal information) worksheet to your original post (OP).

    To do this, edit your OP, go advance mode, click on the attach document icon and upload your document.
    Janos S. Vamos
    Data Systems Technician/Fire Controlman PO1(SW/AW)
    US Navy Retired


    Remember, Record Macro can be your friend for figuring out solutions.

    Good or Bad, let me know how I did by clicking on the "Add Reputation" * just to the lower left of here. it only takes a few seconds to let someone know.

+ 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. IF and AND statements in conditional formatting
    By daowen in forum Excel General
    Replies: 7
    Last Post: 07-25-2013, 12:16 PM
  2. If statements and conditional formatting
    By confusedcontroller in forum Excel General
    Replies: 6
    Last Post: 02-10-2011, 10:08 AM
  3. Conditional Formatting with IF/Then Statements
    By pingwin77 in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 12-02-2008, 10:35 AM
  4. Conditional formatting and If statements
    By redefine in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-06-2007, 06:54 PM
  5. [SOLVED] Conditional Formatting and If Then Statements
    By bullandbear1987 in forum Excel General
    Replies: 2
    Last Post: 10-21-2005, 07:05 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1