Conditional Formatting with Reminder

[bendboyd]

Hi all,
I work in a hospital pharmacy and I'm trying to use my excel spreadsheets to help me monitor our patients. Certain medications require pharmacists to monitor at least every 72-96 hours.

How would I set up a conditional reminder that would notify me if I hadn't completed my monitoring in the last 72 hours?

I'm not an advanced user, so detailed/simple instructions would be very, very much appreciated.

Ben

[etaf]

you can use a formula conditional formatting

Assuming the date and time is in A1

=And(A1<>"", a1<now()-72/24)



Please upload a small clean sample of your data / workbook (not a picture) to the forum, Make sure you have removed any private information, remember this is a public forum and so available to anyone
We would like to see an example of your data and also a manual mock up of the expected results you want to achieve.

To attach a file to your post,
click "Go advanced" (next to quick post),
scroll down until you see "manage Attachments",
click that and select "Choose File" (top Left corner).
Find your file, click "Open" click "upload" click 'close windows" Top Right. click "Submit Reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.

[mikeTRON]

Do you have a sample spreadsheet for us to help you with?

[bendboyd]

See attached

[bendboyd]

So, I open this spreadsheet everyday. Typically, there are 60-70 different sheets (one for each patient). We put our initials in the 'RPH' column whenever we complete monitoring for that day. Is there a way I can set the Reminder column to alert me if the RPH column is empty for the last 3-4 days?

[mikeTRON]

Where would you want the reminder and where is the data when you HAVE put your initials?

EDIT: I think I see now.

Please Login or Register  to view this content.

would be the conditional formatting formula to use in Q10 and down.

[bendboyd]

I've actually never done a reminder on excel. Would there be a pop-up box for each reminder setup upon opening the file?

So, we fill out the data horizontally on the dates that we review the patient, then put our initial at the end of that Row. Basically, the RPH initial at the end of each Row would determine if the review had been completed.

Does that answer your questions?

[bendboyd]

I've actually never done a reminder on excel. Would there be a pop-up box for each reminder setup upon opening the file?

So, we fill out the data horizontally on the dates that we review the patient, then put our initial at the end of that Row. Basically, the RPH initial at the end of each Row would determine if the review had been completed.

Does that answer your questions?

[bendboyd]

=And(Q1<>"", 11<now()-72/24)

So I would paste that into column Q? From Row 10 on down?

[etaf]

you need to decide how you want to proceed
-72 hours
RPH blank

you could check for both

=And(A10<>"", A10<now()-72/24, Q10="")

this will check for
A10 not being blank
Q10 being blank - ie NO Initials
And
A10 Date is greater than 72 hours before the time you open the sheet

and colour the cell RED

BUT also if you put
=IF(AND(A10<>"", A10<NOW()-72/24, Q10=""), "CHECK", "")
into R10

and copy down that will add the word check - but does not create a POP-UP