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 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.
Tnx Klaas, Once I had figured out how to make the three conditions I was able to set it up easily. Tnx Hylton --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
