 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / May 2008Conditional formatting
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 [quoted text clipped - 5 lines] > Thanks, > wiersma7 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 >Column 2 is linked to the first column. Try something like this: =IF(A1="","",A1)  SignatureBiff Microsoft Excel MVP >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 [quoted text clipped - 5 lines] > Thanks, > wiersma7 |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.