Conditional formatting and percentages

  • Thread starter Thread starter Scott
  • Start date Start date
S

Scott

Hi

I have some figures in a spreadsheet that a saved as the percentage
format. If want have traffic lights colouration for these and if i wish
to have any of the percentages that are between 0% and 2.5% percent to
be (green) coloured. But because these figures are percentages I have
to insert values between 0 and 0.025 which seems a little silly to me?
Is there not an easier way of doing this as it looks as through errors
could easily be made like this?

The other 2 traffic lights are between 2.5% and 10 is (orange) and
anything greater than 10% is (red).

Please help me!

Scott
 
Scott,

Excel works with numbers. A percentage is a number. If you enter 2.5 in a
cell and format it as a percent, it will display as 250%
2.5% = .025
10% = 0.10
Understanding the decimal representation of a percentage is important.

Jim
 
Back
Top