hide cell contents and make it reappear (Excel)

[Guest]

I need to hide the contents of a column of cells and make each corrisponding
cell contents reappear when another cell value changes from "current" to
"overdue"

 

[CarlosAntenna]

=IF(<reference cell>="overdue",<your formula here>,"")

-- Carlos

 

[Guest]

Dave
If I understand you right, you don't want the whole column hidden (so that
the column headings skip from C to E, for example), you just don't want the
values visible until some other cell changes to read "overdue". If this is
correct, I suggest changing the font color of the cells you want invisible to
the same color as their background (which probably means white). Then use
conditional formatting on these cells to cause the font to change to a
visible color (red?) based on the appropriate cell containing "overdue".

Hope this helps.

Will

 

[Gord Dibben]

Use Conditional Formatting on the cells.

Select the cells to change.

Format>Conditional Formatting>Formula is:

=A1="current" where A1 is the cell with "current" or "overdue"

Format>Font>White


Gord Dibben Excel MVP