2007/4/15, Hylton Conacher (ZR1HPC) <[EMAIL PROTECTED]>:
Klaas Visser wrote: > 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'm glad you solved your problem. Just of curiosity, what will happen if the vallue is 901-999? It would also be interesting to see what happens if the value is 751-758. I think it will be Light Green, since only the first condition that match is "executed". Johnny Andersson