I have a formula in a cell
(=SUM(Apr.D3:Apr.D30)/(COUNT(Apr.D3:Apr.D32)*30)*1000) and would like
the cell background of that same cell change colour as the formula
result changes.
If the formula result is 0-758, the cell can be Light Green. If the
value of the formaula is 751-900 the cell colour would be orange. If the
formula result was over 1000 then the cell must be coloured Light Red.
I was thinking of exploring the IF function but am not sure:
1. If this can be done
2. What the correct formula to use would be.
Any thoughts/suggestions?
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
