Is it possible to highlight a cell that caused an IF function to fail?

[jastrick97]

I have a pretty long if function that returns checks multiple fields for specific values. I would like to format the cells that cause the If function to fail to fill with red color. I do not want to highlight the actual "true","false" returns. I need to know what specific field or multiple fields that caused the function to fail. Is this possible?

**I'm working in pivot tables.

My current function:

=IF(Query[Material Type]="GF" && Query[MRPController]>"699" && Query[MRPController]<"800" && Query[ProcurementType]="E" && Query[LotSize] in {"ZE","EX","ZM","ZX"} && Query[DefaultStorLocExtlProc]="1008" && Query[IssueStorageLocation]="1008" && Query[StrategyGroup] in {"40","Z2"} && Query[PeriodIndic]="W" ,"","Error")

[63falcondude]

I recommend uploading a small representative sample of your data along with the desired results (which you can enter manually) based on that data.

To upload an Excel workbook, follow these steps:
1) Click on "Go Advanced"
2) Click on "Manage Attachments"
3) Click on "Choose File"
4) Choose your file and click on "Open"
5) Click on "Upload"
6) Click on "Close this window"

[Sam Capricci]

wasn't this mentioned in your earlier post here https://www.excelforum.com/excel-for...ml#post5136548
Part of the issue is you cannot have a greater than 699 when 699 is text and 699 is text when you put quotes around it. That is like saying something is greater than "dog".
And what is the && for? Is that supposed to be that if the first item = "GF" and the second item is greater than "699"? You should write that as something like =IF(AND(Query[Material Type]="GF",Query[MRPController]>699 etc...
Hope that helps.

[jastrick97]

The <> "699" is working as intended. The && is an And operator within DAX (power pivot). The function is working fine.
All I want to know is how to Color fill the specific cells that trip the formula and result in a false or "Error"