On 15-Apr-07 16:50 (+1000 UTC), *Hylton Conacher (ZR1HPC)* posted:
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?
I'd be using Conditional Formatting for this.
Create three cell styles, one for each of the result states / fill colours.
Go to Format | Conditional Formatting, and specify the appropriate cell
values, and the style to use in each case.
Klaas Visser
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
