At the bottom of the conditional formatting dialog there's an Add button
that allows you to put in a second condition & a different format

You'd simply want the first one to be
=AND(B1A1,NOT(ISNA(C1)))

and the second one would be
=AND(B1<A1,NOT(ISNA(C1)))

QUESTION: what do you want to do if A1=B1?


"carl" wrote:

thank you duke.

i ran into another scenario and wondered if the conditional formating can
help me identify it:

IF A1-B1<0 and C1<#N/A do format condition 1 but if A1-B10 and C1<#N/A,
do format condition 2.

Is this possible to do with the excel conditional formating ??

"carl" wrote:

Is it possible to have the conditional format feature to flag a row if the
following conditions exists:

A1<1, B15, C1<#N/A

Thank you in advance.