rjplante
Well-known Member
- Joined
- Oct 31, 2008
- Messages
- 572
- Office Version
- 365
- Platform
- Windows
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?
=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?