| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Conditional Formatting question (if cell = 0, wrap cell in quotes)
IF Cell value = 0, wrap with quotes
not exactly quotes.. but with this number format: ""'#0"'," wrapped in single quotes, followed by a comma. (format-cells - costum , to see what it looks like) also, i dont want it to apply to every column (if its possible to do that) just A1:A323, B1:B323, E1:E323, G1:G323, I1:I323, K1:K323 thanks in advance |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| wrap quotes | Excel Worksheet Functions | |||
| Why won't text in cell wrap. Cell format set to wrap. | Excel Discussion (Misc queries) | |||
| Conditional cell background formatting, based on cell content | Excel Discussion (Misc queries) | |||
| Conditional Formatting Question - Different Cell Colors?? | Excel Discussion (Misc queries) | |||
| Wrap text limits in Excel 2003 cell formatting | Excel Discussion (Misc queries) | |||
Threaded Mode
