Hi all

Not sure if this can be done at all, and hope someone here might be able to
help me first let me give you a run down of what my spreadsheet is.

Have a workbook with different sheets for every month in the year, which i
use to record the number of cases received. Keeps a record of each case
received and gives breakdowns of totals received for the month and year to
date etc.

What i need to do is using the running total on each sheet (i.e. total cases
received for the year to date) and have the spreadsheet calculate every fifth
case received (i.e. 1 in 5) that is received and either highlight the
specific row a different colour or put up a pop up message to say the case
needs to be audited.

If you need anymore information from me just let me know otherwise i hope
someone can help me out and thank you in advance for your time and help.

Matt