Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Custom cell format
Hi All,
I am pretty sure this can be done, but l cant seem to get the syntax right! I would like to create a custom format that displays the cell value as a % but if the % 100% or < 100% then **** is displayed. I thought it would go something like this: [100%]["****"]0.0%;[<100%]["***"](0.0%) Can anybody give me the correct syntax please? If this cannot be done as above can l achieve the same result by conditional formatting and if so how? All ideas greatfully received Regards Michael Beckinsale |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Custom cell format
On Tue, 27 May 2008 07:46:34 -0700 (PDT), "michael.beckinsale"
wrote: Hi All, I am pretty sure this can be done, but l cant seem to get the syntax right! I would like to create a custom format that displays the cell value as a % but if the % 100% or < 100% then **** is displayed. I thought it would go something like this: [100%]["****"]0.0%;[<100%]["***"](0.0%) Can anybody give me the correct syntax please? If this cannot be done as above can l achieve the same result by conditional formatting and if so how? [<1]"****";0.0% Based on your description, you only want to show the number if it's exactly 100%. -- Dick Kusleika Microsoft MVP-Excel http://www.dailydoseofexcel.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
format cell custom Number format | Excel Worksheet Functions | |||
Format Cell as custom type but data doesn't display like I custom. | Excel Discussion (Misc queries) | |||
Custom Cell format to mimic time format | Excel Discussion (Misc queries) | |||
Format a cell with a custom number format | Excel Worksheet Functions | |||
Custom format that shows blank cell if another cell is empty | Excel Discussion (Misc queries) |