+ Reply to Thread
Results 1 to 2 of 2

Conditionally format a cell based on multiple criteria including format cell

  1. #1
    Registered User
    Join Date
    07-03-2014
    Location
    London, England
    MS-Off Ver
    2013
    Posts
    5

    Conditionally format a cell based on multiple criteria including format cell

    Hi

    I'm trying to conditionally format a cell based as follows;

    In C7 there is a drop down list with options "High Value High Risk" or "High Value Low Risk"
    In F7 the user enters a number from 1 to 5 which relates to their level of certification

    High Value High Risk needs to be level 4 or above - when the user types 4 or 5, F7 needs to highlight green. Anything less than 4, the cell needs to go red.
    High Value Low Risk needs to be a minimum of 3 - when the user types 3 or above, F7 needs to highlight green. Anything less than 3 needs to go red.

    I've tried various ways of doing it, most recently as below...

    =AND($C7="High Risk High Value",F7>3)

    Is this not working because the cell I'm trying to format is one of the conditions?? After two hours of intensely googling I am hoping someone can help me before I go completely insane.

    Thanks

  2. #2
    Valued Forum Contributor
    Join Date
    09-21-2011
    Location
    Birmingham UK
    MS-Off Ver
    Excel 2003/7/10
    Posts
    2,188

    Re: Conditionally format a cell based on multiple criteria including format cell

    Hi,

    I have just done

    =AND($A$4="High",$B$4>3)

    in B4 and it was ok

    Can you attach yours?
    Hope this helps

    Sometimes its best to start at the beginning and learn VBA & Excel.

    Please dont ask me to do your work for you, I learnt from Reading books, Recording, F1 and Google and like having all of this knowledge in my head for the next time i wish to do it, or wish to tweak it.
    Available for remote consultancy work PM me

+ 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. Conditionally format currency based on another cell
    By hugowhere in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-28-2014, 03:41 PM
  2. Replies: 7
    Last Post: 11-25-2013, 02:19 AM
  3. [SOLVED] Conditionally format cell based on dates within a number of days apart
    By mjy58 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-24-2013, 06:01 PM
  4. Conditionally Format Row Based on Leading Cell
    By 605Scorpion in forum Excel General
    Replies: 7
    Last Post: 06-12-2010, 08:26 AM
  5. Conditionally change number format based on another cell's value
    By Fidd$ in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 12-03-2009, 07:58 AM

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