Currently I have a worksheet that shows percentages in various cells. I would
like to use conditional formatting to show cell colors for certain percentage
ranges and still use the % sign. How can I do this? Currently, I am using

cell value is equal to or less than 94 = red cell
cell value is between 95 and 99 = yellow cell
cell value is equal to or greater than 100 = green cell