If I understand you correctly, use
=ROUND(B12/$B$10, 1) to round 0.46 to 0.50
This changes the STORED value while formatting only changes the DISPLAYED
value.
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"SunshineinFt.Myers" wrote in
message ...
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?