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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditional Formatting of Percentages 2
IF - formatting problem 8
Conditional Formatting Question 1
color coding values 1
Capturing conditional Interior Color of cell 2
Button Color based on cell 12
Need urgent help 0
Conditional Formatted Colored Cells 1

Back
Top