Im working in excel.
In row 3 i have 12 goals (D-O) for my full time associates.
Under that, I have my Full Time associates listed with their results under the goal.
In row 17 i have 12 goals
(D-O) for my part time associates.
Under that i have my Part Time Associates listed with their results under the goal.
In row 24 I have 12 goals
(D-O) for my D Status Associates
Under that i have my D Status associates listed with their results under the goal.
They all have a Total column in
I want the associate total to turn green if the associate meets their goal, but here are the two catches. If an associate is
hire mid year, two things happen that mess up my current formula used in the conditional formatting.
1) when my
macro to insert a row is run, it puts a new row into whichever named range (Fulltime, Parttime, or DStatus) and the formula
is thrown off because the reference rows change.
2) when the associate is hired mid year, they get
values of " '--------- " in every results cell so that they arent counted in the count function and don't turn red
because of a 0 result vs goal. The problem here which is solved in my first formula, but i simply dont understand how it
works, is that their total should only turn green if the month goals, aera dded, but only the months they are actively
employeed. IE They are not added from feb-jan if the associate was hired in aug because then the goals that apply to them in
the real world are only aug - jan.
Here is the conditional formatting im using currently...
Please feel free to look at the
attatched file to see what i mean
Please help me understand #2, and fix #1