Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional format
Hi, how do I display a cell as follows:
If it's <50, show it as a % If it's 50 show it as a decimal It needs formating in the actual cell that the manager would enter a figure into. Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional format
Try a custom format of
[<.5]0%;General -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Bee" wrote in message ... Hi, how do I display a cell as follows: If it's <50, show it as a % If it's 50 show it as a decimal It needs formating in the actual cell that the manager would enter a figure into. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
custom format or conditional format? | Excel Discussion (Misc queries) | |||
How to create a conditional format that changes the number format | Excel Discussion (Misc queries) | |||
Conditional Format - Format Transfer To Chart | Excel Discussion (Misc queries) | |||
copy conditional format to regular format | Setting up and Configuration of Excel | |||
copy conditional format as ACTUAL format | Excel Discussion (Misc queries) |