| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How do I change the format of a cell based on what I input?
OK... here's the question. I have a cell that I input a number into. If I
input a number less than 1, I want the cell to be formated with a percentage sign. If I input a number greater than 1, I want it to show just as a number (with no percentage sign). I would prefer the answer NOT include a macro as this worksheet will be used on older computers that have a hard time running macros. If it can't be done without a macro then a macro will be OK. Any thoughts? and thanks very much.... |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Format text in one cell based on value in another cell | Excel Worksheet Functions | |||
| Can I format a cell in excel based on a list of about 20 items? | Excel Discussion (Misc queries) | |||
| Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions | |||
| Format cell in column B based on value in the next cell (column c) | Excel Discussion (Misc queries) | |||
| How do I change the value in cell based on a future date | Excel Discussion (Misc queries) | |||
Threaded Mode
