Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using F2 - How do you do 3,000 entries all at once? | Excel Discussion (Misc queries) | |||
Displaying an error message if entries exceed 100% | Excel Discussion (Misc queries) | |||
Legend Entries | Charts and Charting in Excel | |||
How do I change multi-line entries to single line entries in Exce. | Excel Worksheet Functions | |||
changing the message in an error message | Excel Worksheet Functions |