+ Reply to Thread
Results 1 to 1 of 1

Excel 2007 : need help with conditional formatting a spreadsheet

  1. #1
    Registered User
    Join Date
    03-19-2012
    Location
    South Carolina, USA
    MS-Off Ver
    Excel 2007
    Posts
    1

    need help with conditional formatting a spreadsheet

    I am trying to make a graph for work that shows the deviation of a timed process in a row on a spreadsheet. I have a row of cells from H1 to AG1. Cell G1 will have a numeric value that can be anywhere from “0” (zero) to “25” (twenty-five). Based on that number in cell G1, I want to place a colored icon in a particular cell from H1 to AG1. The ranges I am trying to focus on are that cell H1 would represent 0; I1 would represent 1; J1 – 2; K1 – 3; etc. Zero to Three would be “green”, Four to Ten would be “yellow” and, Eleven to Twenty-Five would be “red”. For example: If the number in G1 is “3”, then I would have a round green icon in cell K1; if the number were “4”, then a round yellow icon would be in cell L1; “11” would have a round red icon in cell S1, and so on.
    I have toyed around with conditional formatting, but the rules are limiting and my knowledge of formulas is also limited. Any suggestions would be greatly appreciated. Hopefully this is not too confusing to visualize in written form.

    After reading this post, I realized that it is not worded properly, which is probably the reason that it has many viewers and no replies. I will attempt to reword this and post it to another site. Thanks, anyway.
    Last edited by bimfi; 03-22-2012 at 04:08 PM. Reason: too confusing?

+ 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