Use Conditional Formatting.

Select column A
Menu FormatConditional Formatting
Change Condition 1 to Formula Is
Add a formula of =A1=1
Click the Format button
Select the Pattern Tab
Select green colour
OK
OK

Second condition

Click Add
Change Condition 2 to Formula Is
Add a formula of =A1=.9
Click the Format button
Select the Pattern Tab
Select yellow colour
OK
OK

--
__________________________________
HTH

Bob

"marlin svitak" <marlin wrote in message
...
need to use for visual aid on how we are doing percentagewise on usage of
time budgeted for cycle and time actually running