| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Rectangle Box
Hey all,
I have several boxes that equal cells with formulas. They all show blank ( I have them formatted as no background and no lines) when there are no results in their associated cells. However, when even just 1 of the boxes has a referenced cell return a formula, they all show a result, even it it's zero. eg. Rectangle 41 = Q60 Rectangle 42 = Q61 etc, etc. When a result is returned in cell Q60, rectrangle 41 displays the correct data, BUT, rectangle 42 displays 0 .... Why is this happening? Shouldn't the rectangles show results ONLY when there are results to show? Help please .... |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to show the rectangle box position | New Users to Excel | |||
| Confining a point in a rectangle | Excel Discussion (Misc queries) | |||
| Delete a rectangle using a macro | Excel Discussion (Misc queries) | |||
| Copy Rectangle Object From One Sheet To Another | Excel Discussion (Misc queries) | |||
| Formatting Auto Shapes - Rectangle | Excel Discussion (Misc queries) | |||
Threaded Mode
