I have spreadsheet that has conditions and depending on those conditons the
cells changed color. For example: if cell is less than .29 or = to .29 turn
the cell red. Now this cell that has the actual number is next to the cell
that shows the % and then the color and the conditional cell has a formula in
it. =B12/$B$10. Example: Cell B12 =54 and cell B10 has a total formula thus
giving me the number 39. How can I put a formula in the cell that already has
the =B12/$B$10 that will round the number up say from .46 to .05 thus
updating my color? See right now it does not change to the next color even
though I decrease the decimal point. I want to round up in the condional
formatting. Help?