I have set up some conditional formatting. This checks column C for a match to "DER" and if it does it checks for anything that doesn't match on a separate sheet called "DOR". 99% of them work correctly and highlight anything missing from the DOR sheet, but a few don't eg ABC1826 below highlights as missing when it isn't. Both are correctly listed on DOR sheet and aren't missing but unsure why ABC1825 works and ABC1826 doesn't. Everything appears identical on both including cell formats etc
Any ideas what else to check?
Any ideas what else to check?
14Dec.xlsm | ||||
---|---|---|---|---|
B | C | |||
202 | ABC1825 | DER | ||
203 | ABC1826 | DER | ||
EZY Allocations |
Cells with Conditional Formatting | ||||
---|---|---|---|---|
Cell | Condition | Cell Format | Stop If True | |
B4:B274 | Expression | =IF(C4="DER", COUNTIF(DOR!$A$7:$A$1000,B4)=0, "") | text | NO |
C4:C274 | Cell Value | ="DER" | text | NO |
B4:M274 | Expression | =$G4<>$G3 | text | NO |