color coding cells by percentage 100% = green 90% yellow etc.
 

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

color coding cells by percentage 100% = green 90% yellow etc.
 

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