Hi,
I am using Alerters as traffic lights to prompt team leaders where agents are hitting/missing targets etc.
I have got the logic/figures right with the way this is set, however I seem to be having a formatting issue.
Examples:
This example works fine, however the 11.6 entry is manually input and i want a variable to make this go Green/Red as the figure will change on a daily basis
Cell Contents - Greater than or equal to - 11.6 (calls per hour) = Green
Cell Contents - Less than or equal to - 11.6 (calls per hour) = Red
This Example does not work when pointing to a variable.
Cell Contents - Greater than or equal to - Hit Target(variable name) = Green
Cell Contents - Less than or equal to - Miss Target(variable name) = Red
Can someone please help me with this please!
Thanks very much.
p.s. points will be given Generously.
Kellyx