ExcelBanter - Conditional formatting again

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Conditional formatting again (https://www.excelbanter.com/excel-discussion-misc-queries/154447-conditional-formatting-again.html)

Kim

Conditional formatting again

I have anticipated ship date in workbk 'Full Log'!K5
I want anticipated ship date in 'Sub Log'!F5
When I put in formula ='Full Log'!K5 and there is no value in the column, I
get 01/0/1900 and I don't want that I would prefer for it to be blank for the
people who are looking at the information are becoming confused. How can I
do it?

Kim

Conditional formatting again

Once again Danny to the rescue!
Thanks!

"kim" wrote:

I have anticipated ship date in workbk 'Full Log'!K5
I want anticipated ship date in 'Sub Log'!F5
When I put in formula ='Full Log'!K5 and there is no value in the column, I
get 01/0/1900 and I don't want that I would prefer for it to be blank for the
people who are looking at the information are becoming confused. How can I
do it?

Danny

Conditional formatting again

Kim,

You can try it with an IF function:

IF('Full Log'!K5="","",'Full Log'!K5)

"kim" wrote:

I have anticipated ship date in workbk 'Full Log'!K5
I want anticipated ship date in 'Sub Log'!F5
When I put in formula ='Full Log'!K5 and there is no value in the column, I
get 01/0/1900 and I don't want that I would prefer for it to be blank for the
people who are looking at the information are becoming confused. How can I
do it?

All times are GMT +1. The time now is 02:56 PM.