When I use the conditional formatting for the color change, I get the
drop down boxes, and choose:
"Cell Value Is"
"Less Than"
And then for the formula, I try D4/2. I also tried $D$4/2.
I'm basically trying to say if less than 50%. Neither works, it always
comes back as true even if its not.
To clarify, all of row '4' contains the possible scores for each task.
Then going down the chart (rows 5 onward), you get the individual
scores for each task. Like:
Column D E F G H
Row
4 20 15 20 15 20
5 12 10 8 7 17
6 8 13 14 12 7
7 16 12 13 11 9
--
gibson00
------------------------------------------------------------------------
gibson00's Profile:
http://www.excelforum.com/member.php...o&userid=36231
View this thread:
http://www.excelforum.com/showthread...hreadid=560168