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.
Hope that Helps
New users should read the Forum Rules before posting
For free Excel tools & articles visit my web site
If I have helped you and you feel like putting your hand in your pocket please make a donation to Children in Need
RoyUK's Web Site
royUK's Database Form
Where to paste code from the Forum
There are currently 1 users browsing this thread. (0 members and 1 guests)