+ Reply to Thread
Results 1 to 3 of 3

Advanced Conditional Formatting Ideas Needed! (ok, maybe not that advanced...)

  1. #1
    Forum Contributor
    Join Date
    03-12-2004
    Posts
    147

    Advanced Conditional Formatting Ideas Needed! (ok, maybe not that advanced...)

    Two questions:

    1. Can I have a conditional format that is dependant on two different cells? For example in Cell A2 I want to have the cell turn bright red if A2 is greater than zero and B2 equals zero. I want to then drag this down for every cell in column A.

    2. I cell C2 I want to turn this cell bright red if cell D2 gets the error message "DIV/0!" to flag there is an error. Is this possible?

    Thanks

  2. #2
    Forum Expert oldchippy's Avatar
    Join Date
    02-14-2005
    Location
    Worcester, UK
    MS-Off Ver
    Excel 2007 (Home)
    Posts
    7,099

    Thumbs up

    Hi shadestreet,

    Try this,

    Conditional formatting for B2
    formula is > =IF(A2>0,IF(B2=0,TRUE,FALSE))
    select formatting required

    Formula in cell C2
    =IF(ISERROR(D2),"Error","")

    Conditional formatting for C2
    formula is > =ISERROR(D2)
    select formatting required

    Is this what you require?

    oldchippy

  3. #3
    David Biddulph
    Guest

    Re: Advanced Conditional Formatting Ideas Needed! (ok, maybe not that advanced...)

    "shadestreet" <shadestreet.2bas4e_1153488908.2635@excelforum-nospam.com>
    wrote in message
    news:shadestreet.2bas4e_1153488908.2635@excelforum-nospam.com...
    >
    > Two questions:
    >
    > 1. Can I have a conditional format that is dependant on two different
    > cells? For example in Cell A2 I want to have the cell turn bright red
    > if A2 is greater than zero and B2 equals zero. I want to then drag
    > this down for every cell in column A.


    Formula is:
    =AND($A2>0,$B2=0)

    > 2. I cell C2 I want to turn this cell bright red if cell D2 gets the
    > error message "DIV/0!" to flag there is an error. Is this possible?


    Formula is:
    =(ERROR.TYPE(D2)=2)
    --
    David Biddulph



+ 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