Results 1 to 2 of 2

Status Light Excel 2010

This is a discussion on Status Light Excel 2010 within the Excel Questions forums, part of the Question Forums category; I am trying to figure out how to make status indicator for my excel document. In Column "B" I would ...

  1. #1
    New Member
    Join Date
    Feb 2013
    Posts
    2

    Question Status Light Excel 2010

    I am trying to figure out how to make status indicator for my excel document. In Column "B" I would like a red, yellow, or green dot to appear if they meet the following criteria:

    Green: F - J filled in
    Yellow: 3 out of the five columns are filled in
    Red: None of the columns are filled in.

    Would anyone be able to help me out with this?

  2. #2
    MrExcel MVP
    Join Date
    May 2009
    Posts
    6,766

    Default Re: Status Light Excel 2010

    Quote Originally Posted by JWOOD1650 View Post
    I am trying to figure out how to make status indicator for my excel document. In Column "B" I would like a red, yellow, or green dot to appear if they meet the following criteria:

    Green: F - J filled in
    Yellow: 3 out of the five columns are filled in
    Red: None of the columns are filled in.

    Would anyone be able to help me out with this?
    You can use conditional formatting for this. This will get you started:
    1) In column B select all the cells you want to contain the dots.
    2) Enter =CHAR(108) and press ctrl + enter keys
    3) set font to Wingdings (you should now have dots in all the selected B cells).
    4) Use the following conditional formatting formulas to set dot colors:

    =COUNTA($F2:$J2)=5 SET FONT TO GREEN
    =COUNTA($F2:$J2)=3 SET FONT TO YELLOW
    =COUNTA($F2:$J2)=0 SET FONT TO RED
    Joe

    When I was a young man I knew everything. Now that I'm older, I realize I know very little, and what I do know, I tend to forget!

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


DMCA.com