Home |
Search |
Today's Posts |
#1
|
|||
|
|||
how do I hide cell value
I am using this formula. =if(isblank(d6),sum(c7), sum(c7+d6))... which
would be for cell D7. It works so that if cell D6 is blank, then it takes it's value from the neighboring C7... otherwise, it just adds C7 and D6 to get D7. It works fine, however, I want to know if I can get D7 to LOOK empty but hold the value from the formula when C6 was indeed empty. I've seen how to use conditional formatting to If is = to 0 then white.. but, can I use that somehow to color out the value that would be from the C7 value? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hide Value of Cell | Excel Discussion (Misc queries) | |||
Hide text that doesn't fit in the cell | Excel Discussion (Misc queries) | |||
How do I add a date formula to a cell but hide the contents with . | Excel Discussion (Misc queries) | |||
GET.CELL | Excel Worksheet Functions | |||
VLookup resulting in a blank cell... | Excel Worksheet Functions |