Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
what formula could I use?
I have a large quoting template, with multiple pages, which provides the cost
of a part when the sales rep enters a part number. Because some of the quotes get very large, there are 120 rows in which the sales rep could potentially enter a part number. With that many rows, people tend to miss marking up the cost of the product and then end up quoting it to the customer at our cost. I need some sort of reminder for the salespeople to markup the cost of a part if they have entered a quantity next to a part number. The rows below the following column headers require manual entry: Column A = Quantity Column B = Part Number Column N = Customer Markup Does anyone have any recommendations on what sort of formula, or conditional formatting I could use to help easily notify the rep if they haven't entered a % in Column N when there is a Quantity in A? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
what formula could I use?
If you simply want to remind them to enter data in N then you could use data
validation:- Data|validation|Input message tab Type a suitable title and message then whenever the cell is selected the message will be displayed. Another way would be to build a lookup table such that when a value is entered in A it looks up the part number and returns the markup automatically to column N but this would become more difficult if the markup varied. Mike "NANGO" wrote: I have a large quoting template, with multiple pages, which provides the cost of a part when the sales rep enters a part number. Because some of the quotes get very large, there are 120 rows in which the sales rep could potentially enter a part number. With that many rows, people tend to miss marking up the cost of the product and then end up quoting it to the customer at our cost. I need some sort of reminder for the salespeople to markup the cost of a part if they have entered a quantity next to a part number. The rows below the following column headers require manual entry: Column A = Quantity Column B = Part Number Column N = Customer Markup Does anyone have any recommendations on what sort of formula, or conditional formatting I could use to help easily notify the rep if they haven't entered a % in Column N when there is a Quantity in A? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
what formula could I use?
In Excel 2007 - This is a simple task
In conditional formatting tab New Rule.. "Use a formula to determine which cells to format" A1<0 -- set the format desired Copy this format for all the cell which you want to higlight. For XL2003 --- I am not sure, but there must be an equivalent way. "NANGO" wrote: I have a large quoting template, with multiple pages, which provides the cost of a part when the sales rep enters a part number. Because some of the quotes get very large, there are 120 rows in which the sales rep could potentially enter a part number. With that many rows, people tend to miss marking up the cost of the product and then end up quoting it to the customer at our cost. I need some sort of reminder for the salespeople to markup the cost of a part if they have entered a quantity next to a part number. The rows below the following column headers require manual entry: Column A = Quantity Column B = Part Number Column N = Customer Markup Does anyone have any recommendations on what sort of formula, or conditional formatting I could use to help easily notify the rep if they haven't entered a % in Column N when there is a Quantity in A? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|