Conditional formatting

  • Thread starter Thread starter wiersma7
  • Start date Start date
W

wiersma7

I have 2 columns that have dates. In column 1 I enter a date. Column 2 is
linked to the first column. If there is no date in column 1, column 2 then
(for I don't know what reason) has "Saturday, January 00, 1900". I want
column 2 to look exactly like column 1. How can I get column 2 to be blank
like column 1?
I was trying as a work around to format column 2 in white if it showed
"Saturday, January 00, 1900".
Thanks,
wiersma7
 
I have 2 columns that have dates. In column 1 I enter a date. Column 2 is
linked to the first column. If there is no date in column 1, column 2 then
(for I don't know what reason) has "Saturday, January 00, 1900". I want
column 2 to look exactly like column 1. How can I get column 2 to be blank
like column 1?
I was trying as a work around to format column 2 in white if it showed
"Saturday, January 00, 1900".
Thanks,
wiersma7
Click to expand...

You might have column 2's formatting as 'date format' ...change the
formatting of column 2 to same as column 1. Ctrl2 on coulmn 1 and then
alt e-s-t on column 2.

hope that helps

Rgds/Agg
 
Back
Top