Hide a formula from a cell

**Sharr76** · 11-20-2009, 01:54 PM

Hi, I have a formula which picks up a date from one worksheet and adds it to the second worksheet.

On the second worksheet I have copied and pasted the formula across all the cells so when I update the 1st worksheet it will automatically update the second worksheet.

this is how its looks:

28/09/09 0/01/00 0/01/00 0/01/00 1/10/06

The first and the last dates are what I want to see in the second worksheet as these have been picked up from some cells in the 1st worksheet, but the three dates in the middle are nothing as the cells relating to these 0/01/00 dates do not have any actual dates in the cells from the 1st worksheet yet.

How can I hide the three dates in the middle until the 1st worksheet is updated?

The formula in the 2nd worksheet is: ='Goss Full List'!F7

This is then copied to other cells.

**scaffdog845** · 11-20-2009, 02:41 PM

Try using the following IF statement

Please Login or Register  to view this content.

If no value exists in 'Goss Full List'!F7 then the cell containing this formulae will remain blank.

**Palmetto** · 11-20-2009, 03:06 PM

Another option:

Use Conditional Formatting to "hide" the zero values by making the font color the same as the cell fill color.

CF formula: = A1=0

**Sharr76** · 11-20-2009, 03:46 PM

Thank you very much!!

One more question....

On my 1st worksheet some dates are a different colour, how would I set the formula to pick the colours up in the 2nd worksheet dates?

**Palmetto** · 11-20-2009, 04:12 PM

On my 1st worksheet some dates are a different colour, how would I set the formula to pick the colours up in the 2nd worksheet dates?

How are those cells colored now? Manually or with a Conditional Format?

If you are using a Conditional Format on the first sheet, then use the same Conditional Format on the second sheet.

If you are doing this manually, then it requires a VBA solution - which could be a bit complex depending on your worksheets.