| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do you hide the value of a cell until data is keyed into anoth
I have a very elaborate spreadsheet that is used by most of the people in my
office. I have three columns that contain formulas that calculate 30, 60 & 120 days from the date keyed into a specific column (ie: =bk2+30). Before a date is entered into [bk2] the date that is displayed is a standard date 1/30/00. I know that you can hide anything that has a zero in that column, but how do you hide that date until an actual date is keyed into [bk2]? Is that even possible? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| macro needed to compare value and copy data underneath it to anoth | Excel Discussion (Misc queries) | |||
| How do I get a cell to count values from a list dependent on anoth | Excel Worksheet Functions | |||
| clicking cell containing text, and a numeric value appear in anoth | Excel Discussion (Misc queries) | |||
| How to prevent copied data from appearing until triggered by anoth | Excel Worksheet Functions | |||
| how can i test whether cell contains keyed constant or a formulae | Excel Worksheet Functions | |||
Threaded Mode
