Inactivity Notice?

J

Jay3253

I would like to make a notice for inactivity in a row. So if nothin
has been written in a row for a long time the whole row flashes o
changes color.

What I have is a very simple way of keeping track of quotes and eac
row is a different quote. If there is no activity on that quote for
while I want it to notify the user there has been no activity for
sertain number of days but I want them to be able to turn it off it th
quote becomes a job in the shop. I don't even know if this is possibl
but I couldn't find anything anywhere else.

Thanks in advance for your help
Jaso
 
F

Frank Kabel

Hi
this could be a little bit difficult. Just as a starting point you may
try the following:
1. Have a look at http://www.mcgimpsey.com/excel/timestamp.html for
creating a timestamp then something is entered in a cell. Adapt this
for your needs to create a specific timestamp for each row (use the
worksheet_change method provided in this link)

2. You may then use 'Format - Conditional Format' to highlight rows if
the timestamp is older than x days. e.g. if you have your timestamp in
column C try the following:
- select the cells (e.g. A1:G100)
- goto 'Format - Conditional Format' and enter the formula
=$G1<TODAY()-14
- choose a format
this will highlight all rows for which the timestamp is older than 14
days.

for more information about conditional formating have a look at
http://www.contextures.com/xlCondFormat01.html
http://www.cpearson.com/excel/cformatting.htm


Additional note: Though it is possible to make a cell blink, don't do
it :)
This would involve further macros (e.g. the OnTime method) and will
slow down your worksheets (also blinking cells shouldn't be a part of
worksheets...)
 
Top