Conditional formatting for a range

Closed
christieramos Posts 1 Registration date Friday November 8, 2013 Status Member Last seen November 8, 2013 - Nov 8, 2013 at 03:57 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Nov 10, 2013 at 09:42 AM
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 response

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Nov 10, 2013 at 09:42 AM
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)))
0