Google Sheets - Conditional Formatting Format Cell Color compare to another column cell value

user_18962385 0
Viewed 21

I was trying to change the cell color if the cell value doesn't in the list of another column using the Conditional Formatting but my formula is wrong so it wouldn't change the color. The formula I had tried:

=AC3:AC<0

Desired Output:

enter image description here

conditional-formatting google-sheets
1 Answers

Try below formula in CF rules.

=IF($A3<>"",NOT(ISNUMBER(MATCH($A3,$C$3:$C,0))),"")

enter image description here

user_55147470
Related