bowada

Posts: n/a

How do I do a conditional format for numbers

I want the cell to format "0.00%" if the value is less than 100 and format
"$0" if the value is greater than 100. Conditional format won't format
numbers.

Thanks
-- bowada

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Keep conditional format when "show pages" from Pivot table	Angus	Excel Discussion (Misc queries)	7	June 30th 05 01:33 PM
Office2000: Conditional format behaves strangely	Arvi Laanemets	Excel Discussion (Misc queries)	1	April 7th 05 08:47 AM
conditional format	Julian Campbell	Excel Worksheet Functions	2	December 15th 04 11:59 PM
copy conditional format as ACTUAL format	Dana Zulager	Excel Discussion (Misc queries)	7	December 7th 04 11:02 PM
Copying a conditional format	Meaux	Excel Worksheet Functions	2	November 29th 04 10:19 AM

All times are GMT +1. The time now is 04:22 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us