Converting Text Fraction to Percentage; Conditional Formatting Not Cooperating; Excel 2007

Hello,

As part of an Excel workbook for my job, I have created a section whereby a user can input a fraction, as text so it does not automatically convert, and then a formula will convert that fraction to a percentage.

That part of the formula appears to work just fine. However, I am having an issue with the conditional formatting I have applied to the percentage cell, which is supposed to color-code the cell based on the percentage that is calculated.

In the attached example, you can see that the percentage cell has been color-coded properly based on the data that has been entered in the fraction cell.

But if you change this fraction to 25/42, which calculates the percentage as 60%, the cell remains white, without any fill formatting.

Some fractions seem to work fine with the formatting, some do not. I have no idea why it likes some and why it doesn't like others.

Please advise as to how this can be fixed so that every fraction that falls within the established percentages shows up color-coded for ease of use.

Thank you!WorkExample1.xlsx

So you're saying if I tell it to color "Between 0.60-0.69", it is not including "0.60" in that range? It's coloring, basically, 0.61-0.69?

If that's true, and I just basically need to make sure that I ask it to color the "ten" ranges (.5, .6, .7, etc) specifically...I will, once I get back to the office tomorrow.

Thank you for the reply.

I Googled an article that suggested that using the ranges was how I had to do it, but if that's not true, I'll certainly implement your method and see if better results are obtained!