Conditional Formatting

[Kariba]

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?

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

 

[kevin9999]

If you're testing for 2 conditions in your first expression, you should use an AND() function: try the following:

=AND(C4="DER", COUNTIF(DOR!$A$7:$A$1000,B4)=0)

 

[Kariba]

I tried that. Still showing ABC1826 in red meaning it's missing from sheet DOR when it isn't.

 

[Kariba]

Found the problem. All sorted. Thanks.

 

[kevin9999]

Glad you got it working, and thanks for the feedback