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

  • Thread starter Thread starter marlin svitak
  • Start date Start date
M

marlin svitak

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
 
Back
Top