+ Reply to Thread
Results 1 to 3 of 3

Excel 2007 : Conditional formatting depending on cell value

  1. #1
    Registered User
    Join Date
    08-22-2011
    Location
    Laval quebec
    MS-Off Ver
    Excel 2007
    Posts
    93

    Conditional formatting depending on cell value

    Hi guys,

    This should be an easy one but can't seam to get it right for some reason...

    Lets say I have a value in A1 ...

    If this value is between :
    85+ = the 72 hour column (A2) would be highlighted
    75 84 = 48 hours column (A3)should be hightlighted
    65 74 = 24 hours column (A4)should be highlighted
    60 - = 911 Column (A5) should be highlighted

    been trying to do this with conditionnal formation by inputing a formula with IF and AND but don't seam to work proprely..

    Any suggestions?
    Attached Files Attached Files
    Last edited by djsouljah; 05-28-2012 at 08:05 PM. Reason: added attachment

  2. #2
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    11,894

    Re: Conditional formatting depending on cell value

    Please note that A2..A5 are not columns, they are cells in column A. The COLUMNS corresponding to your data ranges are E..H. All you need to do is select the cells in each column of the table and apply conditional formatting; you need four formulas:
    Attached Files Attached Files
    Ben Van Johnson

  3. #3
    Registered User
    Join Date
    08-22-2011
    Location
    Laval quebec
    MS-Off Ver
    Excel 2007
    Posts
    93

    Red face Re: Conditional formatting depending on cell value

    excellent thank you very much !!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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