Hello all,

I would like to used conditional formatting to turn values which are less than 1 to a %.

The reason I am doing this is I have this enormous data set my boss gave to me and so I am setting up sort of a box with a slider on the top, and when you slide it it activates the offset function which is linked with the cell yadda yadda yadda,... you get the point (yeah, the point is my boss hates me).

Anyways, is there any way that excel can perform the following function:
-In a single cell, the value is 12,345,876.01 and suddenly it switches to .032 and poof! it turns that into 3.2%.

This is my favorite website.

Thanks in advance,

Alex