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?