K
k1ngy
Hi,
I have designed a sheet to measure staffs work times. In this sheet i put a
workrate time they need to work at and in a column their times are recorded
from other sheets. Using conditional formatting i want their times to turn
red amber green depending on if their time is within 5% higher or lower, so
red is 5% lower, amber is within either way and green is higher than 5%.
The reason for this is so that within the sheet all i have to do is change
the workrate figure and not go into conditional formatting function to change
each one to.
Hope this makes sense please help.
I have designed a sheet to measure staffs work times. In this sheet i put a
workrate time they need to work at and in a column their times are recorded
from other sheets. Using conditional formatting i want their times to turn
red amber green depending on if their time is within 5% higher or lower, so
red is 5% lower, amber is within either way and green is higher than 5%.
The reason for this is so that within the sheet all i have to do is change
the workrate figure and not go into conditional formatting function to change
each one to.
Hope this makes sense please help.