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

"Dave" wrote:

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"