Can I set up a sheet for reagents that will flag expiry dates?
I would like to set up a spreadsheet for reagents that will automatically
flag if a reagent is past its expiry date |
Can I set up a sheet for reagents that will flag expiry dates?
Starting in A1 I have
Reagent Stock date Shelf life Flag AgNO3 1-Jun-08 270 Out of date The formula in D2 is =IF(B2+C2TODAY(),"","Out of date") Additionally (or as an alternative) sue conditional formatting to make the row red Select A2:D2 ( when you have more select A2:D(last row) In Conditional Formatting use: Formula Is : =$B2+$C2<TODAY() and set format to suit your need best wishes PS I have no idea how long a solution of silver nitrate would last, even thought I was a chem prof! -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "haem" wrote in message ... I would like to set up a spreadsheet for reagents that will automatically flag if a reagent is past its expiry date |
All times are GMT +1. The time now is 08:53 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com