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