Hi,

While conditional formatting may be the best way to accomplisht this, there
is another way to accoimplisht this by using format cells.

Select the cell to be coloured and press Ctrl+1 (Format celsl dialog box)

Now under custome category type the following in the Type box

[Red][<0.9]0%;[Green][<0.95]0%;0%

While you do not get the colours you want, it still serves the purpose.

Also remember to format the cell in % format

Regards,




"sslurp00" wrote:

I'm using office 2000, I'm trying to get the text for a row to change colour
according to the value that is calculated as a percentage in the last box...

EG: For values between 0 - 90% Red Text, 91 - 95% Amber, 96 - 100% Green...

Any clues, Thanx...