Select the cells, then:

<Format <Conditional Formatting
Click
Cell Value Is
Click
Equal to
Enter
1

Then, click on "Format", and choose whatever you wish.
Then <OK <OK
And you should be done!
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"patgal77" wrote in message
...
I have formatted a column to display numbers as percentages. I want 100% to
display as bold, but can't seem to apply the conditional formatting to it.
The formatting works fine with plain text.