Conditional Formatting the Rounded Value

[bhenlee]

Hi Experts,

How do i apply conditional formatting to the Rounded Value and not the underlying value in the cell?

If I have 89.97% -- how do i apply conditional format so the formatting reads it as 90.0%?

Thank you

[FoxSeaLady]

Hi

To create a conditional format for a cell based on a rounded value include the Round Function in Excel.

ie if the Cell value in b2 is 89.97 using the create formula option in the Conditional Formating menu use the "Use formula Option and enter the formula as:-
Round(b2,0)=90 an d set the format required.

I hope this helps, if not I can forward a sample.

Cheers