Forum Discussion
Solved
Cell formatting
Hi.
I have a worksheet with products, selling price, cost and discounts from 5 to 50 percent. I would like to highlight any discount that goes below the cost of the goods. I can do this by individual line but what I really want is an easier way because of how much lists I have. Attached is a sample, any information is appreciated.
I'll just go ahead and assume that's correct to give you some help.
The way to insert the conditional formatting is to highlight all the cells that you want to potentially be formatted. In this case, it's E3:N12. Then, on the ribbon, click Home > Conditional Formatting > New Rule.
In the dialog that appears, under "Select a Rule type:" click "Use a formula..." Below, in the "Format values where this value is true:" box, type "=E3<$D3". Click the "Format" button and choose your formatting (I like to click the fill tab and click the yellow box). Then click OK and OK. It should work to meet your needs!
Hi experts,
Any help on my request
Hello!
I think Conditional Fomatting rules will work wonders for your situation. As a point of clarification, is the Avg cost the same thing as the cost of goods? You want the numbers to highlight if the discounted price is less than the avg cost?
I'll just go ahead and assume that's correct to give you some help.
The way to insert the conditional formatting is to highlight all the cells that you want to potentially be formatted. In this case, it's E3:N12. Then, on the ribbon, click Home > Conditional Formatting > New Rule.
In the dialog that appears, under "Select a Rule type:" click "Use a formula..." Below, in the "Format values where this value is true:" box, type "=E3<$D3". Click the "Format" button and choose your formatting (I like to click the fill tab and click the yellow box). Then click OK and OK. It should work to meet your needs!
