View Single Post
  #4   Report Post  
Vic Sowers
 
Posts: n/a
Default


"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'