Posted to microsoft.public.excel.misc

PeggyG

external usenet poster

Posts: 8

Custom Cell Formats

I have a cell formatted using <00. If I enter 100 the result is <100. I want
to add a condition or second part to the format so that if I enter anything
over 100 it removes the <

Thanks in advance for the help!

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
custom formats	The big noise	Excel Discussion (Misc queries)	2	February 1st 07 02:10 PM
Custom cell formats	iggy10284	Excel Discussion (Misc queries)	2	March 2nd 06 05:23 PM
Custom Formats	centerNegative	Excel Discussion (Misc queries)	3	October 7th 05 05:01 PM
Custom Formats	Amanda Cooper	Excel Discussion (Misc queries)	1	May 11th 05 05:56 PM
Custom Formats	becky	Excel Discussion (Misc queries)	6	December 24th 04 01:24 AM

All times are GMT +1. The time now is 08:51 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us