Hi
New to the forum and I am so helping that one of you Excel Gods can show me the error of my ways...so I can go home some time this evening! I like my job...but this is getting crazy! Needless to say that I have been struggling for some time now...you could probably guess that I am generaly reluctant to ask for help---but, I now know...I need help desperately!
I know that this is probably pretty basic but it has me stumped.
Here is what I need to accomplish.
I have a template that generates a % based on inputs--lets say that this value is in cell K3. Depending on another criteria (that is user entered and is in J3) we have established acceptable ranges for the calculated %.
For example if cell J3 = A then if the % in cell K3 is less than 5% it is red, between 5 & 10% it is yellow and greater than 10% it is green. This stop light conditional formatting needs to take place in cell L3.
There are 12 different values that one can select from a drop down list for J3.
To make it simpler--I am posting an attachment.
Please help! I am using Excel 2003
Thanks in advance
Bookmarks