I have a spreadsheet where in column A I enter a date. The date expires after 20 UK working days (4 weeks), I want the spreadsheet to give me an indication/alarm or something that the date has expired, maybe by turning the whole row a different colour or something. Any ideas?
Thanks in advance
Use Conditional Formatting, eg to give a seven day warning in the Conditional Format Dialog Formula is box type
Last edited by royUK; February 21st, 2007 at 21:20.
There are currently 1 users browsing this thread. (0 members and 1 guests)