Forum Discussion
Cell formatting
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!
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.
