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.
>
> Klaas Visser
>
>
If you need to use more than 4 styles (including the style set by default
for the range), you can use the STYLE function with IF.
--
View this message in context:
http://www.nabble.com/Calc-2.04-cell-colouring-dependant-on-formula-result-tf3578678.html#a10000178
Sent from the openoffice - users mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
