CODEWITHSUNDEEP
google-sheetsconditional-formatting
Jun Jie Ong
Jun Jie Ong

Reputation: 67

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

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

Upvotes: 2

Views: 58

Answers (1)

Harun24hr
Harun24hr

Reputation: 36750

Try below formula in CF rules.

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

enter image description here

Upvotes: 1

Related Questions