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.