Sorry for that title but this is difficult to explain. I have uploaded a sample workbook to show it better.
I'm refering to the small blue info box on the right of sheet 1 and also the duplicate on sheet 2.
The left side of the box is where I will insert qualification, and the left mostly are the expiry dates. The details are then replicated in other worksheets as in sheet 2.
I have conditionally formatted column 'X' to 'ALERT' when the date is within 60 days of the expiry date (that bit works OK)
but
if the master info block (sheet 1) doesn't have a date in it down the righthand side, two things happen
1. , the subseqeunt box on the following sheet show the date 0 January 1901 with the 'Alert' flag showing alongside it.
2. The 'Alert' warning flag shows on the master info block (sheet 1)
I would like to hide the 'Alert' and the 1901 date if possible when there is no date in the righthand column.
I hope you can follow this pathetic attempt at explaining the problem.
Additinally for some unknown reason a '0' as appeared in column 'U' on sheet two if you could also advise on that.
Thank you very much
Bookmarks