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?

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?

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?