Use Conditional Formatting on the cells.

Select the cells to change.

FormatConditional FormattingFormula is:

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

FormatFontWhite


Gord Dibben Excel MVP

On Fri, 15 Apr 2005 15:00:30 -0400, "CarlosAntenna" wrote:

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

-- Carlos

"Dave" wrote in message
...
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"