Conditional Formatting Question.

[crdeland]

I've set up a work evaluation workbook with multiple worksheets. For
explanation sake I'll stick with my first worksheet titled "Jan". I
have set it up where I have a name column, month column, shift column
an various other columns for evaluatin purposes. below the names and
under each column I've set up my evaluation formulas. What it does is
calculate each column individually and determine the average.
(example: absenteeism-it will figure out the average hrs of sick time
used by employees that given month) It will also calculate 10% above
& below average as well as 20% above and below average. With office
2007 I've been able to color code each of these to represent a color
via conditional formatting depending where the individual employee
feel per their individual data; i.e. yellow for average, blue for 10%
below average, 20% below is red, beige 10% above average and orange
for 20% above average. What I'd like to do now is have a column to add
up the point scale I've developed based on the color coded system.
Somehow I need to attribute a point system to the colors I've set up
as described above without changing the data in the particular columns/
cells, which gave me the averages, etc. Does anyone know of a way I
might be able to do this? I'm fairly new to excel, but I'd sure
appreciate any advice or other suggestions to accomplish this same
task. Thank in advance!

 

[Guest]

The built in conditional formats allow you to have a default background color
+ colors for 3 conditions. It appears that you want to have 5 conditions.
In order to do this, you'll need to use VBA.

Take a look at this

http://www.ozgrid.com/VBA/excel-conditional-formatting-limit.htm