I have added conditional formatting to the rows/cells that have "0" as an expiration date (sheet2 will give you a little hint on how to do this). You can also use this to conditional format the column so that the wording "No Exp. Date" will show up is a different color.
In order to show this wording, I had to change the formula to start with summing each row of expiration dates - when the sum is then zero (0), it will result in the wording, if not, then it will continue to do as the formula before did. - this means that each cell it sums in a particular row, will need to read zero. Hope this helps


I had to split the two sheets, deleted some columns in the first and save one as a JPG, as the file size was too big to attach. Maybe you can enlarge the JPG to view.

Attached Images

sheet2.jpg (97.4 KB, 21 views)

Attached Files

expDate.xlsm (16.6 KB, 13 views)