Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Highlighting date cells before the event elapses
I need to set up an equipment calibration chart. This means that I will need
to look down the chart and see if a piece of equipment is due for testing (about 2 months should do it). If anyone has any ideas about how to flag up the cell with the due date I would be hugely appreciative. I'm using office 2000 (I think) |
#2
|
|||
|
|||
Hi
lots of ways to approach this .... depending on how much information you want stored (ie do you want a history of equipment calibration or are you just going to keep last & next dates for each item?). if you want just last & next then one way would be .............A..................B................C ...............................................D 1..........Item.........Last Date.........Mths to Next Calibration........Next Date 2........Item 1........1/1/05..............6................................. ............=DATE(YEAR(A2),MONTH(A2)+C2,DAY(A2)) this will then calculate the date of the next calibration for you for each item. Then select column D choose format / conditional formatting choose formula is type =$D2<=TODAY() click format ... go to patterns and choose red click OK -this will make the cell go red if the date of the next calibration has passed then still in format / conditional formatting click ADD choose formula is type =$D2<=DATE(YEAR(TODAY()),MONTH(TODAY())+2,DAY(TODA Y())) click format .. go to patterns and choose a lovely lime green click OK twice this will make the cell go lime green if the calibration is due any time in the next two months hope this helps -- Cheers JulieD check out www.hcts.net.au/tipsandtricks.htm ....well i'm working on it anyway "Dummies isn't any good" <Dummies isn't any wrote in message ... I need to set up an equipment calibration chart. This means that I will need to look down the chart and see if a piece of equipment is due for testing (about 2 months should do it). If anyone has any ideas about how to flag up the cell with the due date I would be hugely appreciative. I'm using office 2000 (I think) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Merging Cells when one cell is a date | Excel Discussion (Misc queries) | |||
Date format of cells | Excel Discussion (Misc queries) | |||
Seed date formats to different year in different cells | Excel Discussion (Misc queries) | |||
Min/Max formulas using cells with date format | Excel Worksheet Functions | |||
Date Formatted Cells | Excel Worksheet Functions |