Conditional formatting using AND statement with Error

[rjplante]

I would like to have a cell that will use a multiple condition for cell formatting. I need the cell to check a cell at the top of the column and if the current cell is in error. I currently have the following in the conditional formatting formula field:

=AND(D$4 = "YES", C11=Error)

This does not result in the yellow cell fill formatting being applied to cell C11.

Is it possible to incorporate an AND statement that uses a standard formula along with an Error statement? If so how do I enter it in the conditional formatting formula field?

 

[Fluff]

Both those last two expressions are looking at the wrong row. They should be looking at C9 & C6 respectively.

 

[rjplante]

I found that I had the formula applied to the whole workbook and not just the cell I wanted (C11). When I made that change along with the formula above, I got it to work. Thanks for all your support.

 

[Fluff]

Glad you sorted it & thanks for the feedback.