Thanks again frank! Hey, I was wondering if their is a way to transfer the
date to another worksheet within a workbox if the exp date is expired. Also
would it be possible to make it so the their will be no spaces left blank
(condense to fill in top-bottem). Thx-Markitos

"Markitos" wrote:

Hello

I have a worksheet with a column that has an exp date. If the date is
today's date or a previous date I would like to have the date turn red. (I
think this function is in conditional formatting but im unsure of a formula)
help! and thanks