+ Reply to Thread
Results 1 to 5 of 5

conditional formating

  1. #1
    bp
    Guest

    conditional formating

    Hello,
    I am trying to figure out how to set the color shading of one cell based on
    another cell.
    so I want to set B1 to green if H1 is 0.
    but the conditional formating looks like it works on 1 cell.

    any help.
    thanks



  2. #2
    JE McGimpsey
    Guest

    Re: conditional formating

    One way:

    Set the dropdown(s) and inputbox(es) to read:


    CF1: Formula is =H1=0
    Format1: <patterns>/<green>



    In article <[email protected]>, "bp" <[email protected]>
    wrote:

    > I am trying to figure out how to set the color shading of one cell based on
    > another cell.
    > so I want to set B1 to green if H1 is 0.
    > but the conditional formating looks like it works on 1 cell.


  3. #3
    Peo Sjoblom
    Guest

    Re: conditional formating

    select B1, use formula is

    =AND(H1=0,H1<>"")


    --

    Regards,

    Peo Sjoblom

    http://nwexcelsolutions.com



    "bp" <[email protected]> wrote in message
    news:[email protected]...
    > Hello,
    > I am trying to figure out how to set the color shading of one cell based
    > on another cell.
    > so I want to set B1 to green if H1 is 0.
    > but the conditional formating looks like it works on 1 cell.
    >
    > any help.
    > thanks
    >
    >




  4. #4
    Forum Contributor
    Join Date
    08-28-2005
    Posts
    298

    conditional formatting

    hi!

    choose "formula is" =H1=0

    -via135


    Quote Originally Posted by bp
    Hello,
    I am trying to figure out how to set the color shading of one cell based on
    another cell.
    so I want to set B1 to green if H1 is 0.
    but the conditional formating looks like it works on 1 cell.

    any help.
    thanks

  5. #5
    MartinW
    Guest

    Re: conditional formating

    Hi bp,
    Here's a very good link from another post.

    http://xldynamic.com/source/xld.CF.html#lights



+ 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