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.
Bookmarks