I have a quote tool that requires each each item quotes must be marked up
manually. The problem is the quote tool is large with many columns and rows
and people tend to forget to look at each row and enter a markup % and then
send out a quote at our cost.

It has to be done per line item, because markup can be different for
different products.

Does anybody have an idea for a macro, or code I can include on a worksheet
to either notify you if you have a product on the worksheet that does not
have a corresponding mark up? Could it be some type of function or
conditional format?

Any ideas would be greatly appreciated.

Thanks

You could try using a conditional format and in the formula put something like
=Markup-BasePrice 0
I generally change the background color.

HTH,
Barb Reinhardt


"NANGO" wrote:

I have a quote tool that requires each each item quotes must be marked up
manually. The problem is the quote tool is large with many columns and rows
and people tend to forget to look at each row and enter a markup % and then
send out a quote at our cost.

It has to be done per line item, because markup can be different for
different products.

Does anybody have an idea for a macro, or code I can include on a worksheet
to either notify you if you have a product on the worksheet that does not
have a corresponding mark up? Could it be some type of function or
conditional format?

Any ideas would be greatly appreciated.

Thanks