Conditional Percentage format

[csotherland]

Hello -

I have a report that dynamically shows either ratios or values based upon the user's selection. How can I use conditional formatting to format the cells as a percent type? I see how to highlight and change font, but not how to change number format.

Thanks for your help!

Carl

 

[acw]

Carl

Rather than using conditional formatting, try using the normal number formatting options. There are various things that you can do directly with this facility. Do a search in HELP for custom number formats.

HTH

Tony