need to use for visual aid on how we are doing percentagewise on usage of
time budgeted for cycle and time actually running

Use Conditional Formatting.

Select column A
Menu Format>Conditional 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 (E-Mail Removed)> wrote in message
news:C33D610A-3871-4D6E-9F4C-(E-Mail Removed)...
> need to use for visual aid on how we are doing percentagewise on usage of
> time budgeted for cycle and time actually running