Thanks for the response.
Seems to be working! Thank you so much!! Now I can stop pulling my hair out:
)
Heather
dominicb wrote:
Good evening Heather
What I think you need to do is set up a cell somewhere with todays date
(=NOW() will always update to todays date when you open the
spreadsheet). In my example, cell E4 contains todays date, D4 the
expiry date. Go to Format Conditional Formatting and select Formula
Is and enter this formula :
=(E4-D4)<30
and then set up the cell / font colour etc and click OK.
HTH
DominicB
--
Heather
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200510/1