Pop up message on 1 in 5 entries
 

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

Pop up message on 1 in 5 entries
 

Hi

Mark your data from row 2 onward.
FormatConditional 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.

--
Regards

Roger Govier


"tuk16664" wrote in message
...
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