Multiple conditional formats and priorities

I'm having trouble with my conditional formating, I was hoping I could get some help with it.

So basically I have a parts lists. For readability I want every other row to be highlighted, so I'm using this formula:

=MOD(ROW(),2)=0 and changing the highlight color

In addition to that, if the sell price is below the cost of the part, then that cell needs to have its text appear in red.

=AND(H16>=0,J16<F16)

With how I have it now, if the text needs to be red, then the cell won't be highlighted. Do I need to combine the two formulas? If so, how?

Hi there,

This one gets a little bit complicated - you need to utilise all three of the conditions which conditional formatting allows:

Condition 1, Format BOLD on HIGHLIGHT:

=AND(H16>=0,  J16<F16,  MOD(ROW(),2)=0)

Condition 2, Format BOLD on WHITE:

=AND(H16>=0,  J16<F16)

Condition 3, Format NORMAL on HIGHLIGHT:

=MOD(ROW(),2)=0

This highlights the text in the cell whenever the arithmetic conditions are correct & maintains the alternate white/highlight pattern of the rows.

Hope this helps - please let me know how you get on.

Best regards,

Greg M

Yep that did it. Thanks a bunch.

Hi again Wilro,

Many thanks for the feedback. You're welcome - delighted to have helped.

Regards,

Greg M