Hi Terry
See sample attached to the link below, you have a sample of a Conditional
Formatting & Data list

http://www.savefile.com/projects/808607562


"Terri" wrote in message
...
Ok - If I hide the row, is there any way to UNHIDE ALL or do I have to go
to each one separately and unhide them.


"MartinW" wrote in message
...
Hi Terri,

Maybe Conditional Formatting will do it for you.

Say your dates are in F2 down.
Highlight F2 to say F100 or however far down you need.
Go to FormatConditional Formatting.
Select 'Formula is' from the dropdown
Put this formula in the next box
=$F$1=1
Click on the Format button and set the font color to white.
OK out and OK again.

Now if you put a 1 in F1 all of your dates will be hidden
Delete the 1 to view them again.
If the dates are hidden and you put a new date in
it will hide as soon as you hit enter.

HTH
Martin




"Terri" wrote in message
...
Can't do that because some I want hidden in that column and some I
don't. The ones with dates are to be hidden and the ones with blanks are
not to be hidden!

"Mike Rogers" <Mike060349@NoxSpamxAOLDOTcom wrote in message
...
Terri

Just to add to Arnie's suggestion, if you need to "unhide" them you
will
select the columns on both sides of the hiden one (ones), right click
and
select "unhide" from the drop down menu.

Mike Rogers

"Terri" wrote:

Hi-Have several columns across, one being a date column. I have a BOGO
(buy
one get one free program). The date column is left blank until that
item is
shipped and when it is shipped, I enter the date.
It is getting rather bulky and I would like to "hide" the dates that
appear
there but want to check them upon occasion.
What is the best way for me to do this (keeping in mind I am a newbie)
and
need instructions as well.
Thanks!