| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
cell shows 0 when referenced cell is null
Hi,
I have a cell in worksheet2 which references a cell in worksheet 1: e.g = Worksheet1!A3 But if A3 in woksheet 1 is empty (null?) the cell in worksheet2 has a 0 in it. Is there any way to get the cell in worksheet2 to also show null? i need it to show null and not "" because of conditonal formatting I have thanks!!! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Replace null string with blank cell | Excel Discussion (Misc queries) | |||
| Cell color based upon cell value | Excel Discussion (Misc queries) | |||
| cell color index comparison | New Users to Excel | |||
| up to 7 functions? | Excel Worksheet Functions | |||
| Identify if a cell is referenced by other cells | Excel Worksheet Functions | |||
Threaded Mode
