Conditional Formatting Question

[lilsnoop]

I am curious is it possible to use conditional formatting to change the background of a cell to possibly five different colors depending on the data that ends up in that cell? For instance with this problem, I'm developing a point scale 1 thru 5-each point has a different color. Depending on the average result, which will automatically get 3 points, I'm assigning 2 points for 10% less than average, 1 point for 20% less than average and visa versa, 4 points for 10% above average and 5 points for 20% above average. Even though until all the data is entered, is there a way to have my data cells color code themselves depending on where each falls depending on where the "average" data falls, from whatever data is entered. I hope this makes sense... In my example I have two columns, shift column & mileage. Mileage will not be a criteria to be graded but is used for this example only. Underneath these columns are three of the five point scales. I used "average" is yellow, 20% above is orange and 20% below is red. Depending on where my average result ends up I'd like my data cells i the Mileage column to have the background fill to the appropriate grade scale. Due to decimal issues anything a .5 or up should round up for clarity reasons. Thanks in advance.. I hope I'm not making this more complicated than it needs to be...

[jetted]

Maybe this can help

Please Login or Register  to view this content.

[lilsnoop]

Thanks Jetted for your assistance. My attachment file was a very basic model of what I'm trying to accomplish if it is in fact possible. I have no personal knowledge of vb coding. I followed your instructions and nothing happened. I'm sure its more of an error on my part, but thanks anyways.