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 individua...
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!
This works great Bryant, thanks for the assistance.