Johnny Andersson wrote: > 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".
Tnx Johnny, It would seem that when I created the formatting, I erroneously didn't think of what would happen if the number was +-950. When tested the cell stayed white so I will need to tweak those conditional styles :) --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
