excel.jpg
I want to use conditional formatting to automatically turn the background red when an sample contains asbestos (ignore the PCB line).
However i want the formula to first check the D kolom if it concerns asbestos i used the formula , and it worked so far, but now after that i want it to check the H kolom (using OR?) if it is either:
-Partially contained
-Contained
-PCHM
So basically i need the formula to check if it concerns an asbestos application, and then after that check if it either is one of those 3 terms i used above, and if so the background should turn red.
If it is one of the below described descriptions, i want the lay out to stay as it is:
- not contained
- < tresh det
- or anything else
Is there anyone that can help me out? thanks in advance!
Bookmarks