"carl" wrote in message
...
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.
Select the row and open the Conditional Formatting dialog box
In the drop down box choose 'Formula is'
In the formula entry area put: '=(A1<1)*(B15)*NOT(ISNA(C1))=1'
|