Pop up message on 1 in 5 entries

[Guest]

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

 

[Roger Govier]

Hi

Mark your data from row 2 onward.
Format>Conditional Formatting> use dropdown for Formula is >
=MOD(ROW()-ROW($A$1),5)=0
Choose format required.
Rows 6, 11, 16 etc. will be formatted as chosen.