CF & %

[Jack S.]

How can I get the cponditional formating of a cell to be
$ if over x and % if less than x?

Thanks

 

[Frank Kabel]

Hi
not possible with CF.

 

[JE McGimpsey]

Conditional Formatting can't effect number format.

You might be able to use Custom formatting instead, e.g.:

Format/Cell/Number/Custom [<1]0.00%;$#,##0.00

 

[Debra Dalgleish]

You can create a custom number format:

Select the cells that you want to format
Choose Format>Cells
On the Number tab, select the Custom category
In the text box, type a format, e.g.: [<1]0.0#%;$0.00
(substitute your value for the 1)
Click OK

In this example, any negative numbers would also appear as percents.

Jon Peltier has a page on Number Formats:

http://www.peltiertech.com/Excel/NumberFormats.html

 

[Guest]

-----Original Message-----
You can create a custom number format:

Select the cells that you want to format
Choose Format>Cells
On the Number tab, select the Custom category
In the text box, type a format, e.g.: [<1]0.0#%;$0.00
(substitute your value for the 1)
Click OK

In this example, any negative numbers would also appear as percents.

Jon Peltier has a page on Number Formats:

http://www.peltiertech.com/Excel/NumberFormats.html

How can I get the cponditional formating of a cell to be
$ if over x and % if less than x?

--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

.
Thanks a lot for your help.