Conditional formatting for a range

[Closed]
Report
Posts
1
Registration date
Friday November 8, 2013
Status
Member
Last seen
November 8, 2013
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
Hi!

I am working on a file where I have to format the cells in one column based on a list place in the same sheet in a different column. Basically what I need is: check if the value on that cell matches with the list that is in the other column. If it matches, then change the cell color.

I am trying to do it using the conditional formatting, the formula section (using "match" formula), but it is not working. I tried already different formulas and I got all the time the same response saying: you can't use conditional formatting for a range of cell.

Can you help me?

Thanks!!

1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
It should work. Could you share what formula you are using in conditional format?

Some thing like this

=NOT(ISERROR(MATCH(A1,$G:$G,0)))