| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Formatting copied cells
How can I format a cell to not display anything when the cell that it is
copied from doesnt have any values in it? |
|
#2
|
|||
|
|||
|
Hi Brett, I think you are are referring to a formula here?
If you have the formula "=A2" in a cell, it will show the value in A2. If A2 is empty, it shows a 0, or even #N/A or something nasty like that. If you change the formula to read "=IF(A2="","",A2)", it will only show a value if there is a value in A2. I hope this is what you were after? "Bret" wrote: How can I format a cell to not display anything when the cell that it is copied from doesnt have any values in it? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need help formatting cells | Excel Discussion (Misc queries) | |||
| How Do I Print 1 Envelope from copied excel Cells without using Wo | Excel Discussion (Misc queries) | |||
| Formatting Cells in Excel | Excel Discussion (Misc queries) | |||
| conditional formatting adjacent cells | Excel Worksheet Functions | |||
| Formatting cells for printing | Excel Discussion (Misc queries) | |||
Linear Mode
