Conditional formatting for a range

Closed
christieramos Posts 1 Registration date Friday 8 November 2013 Status Member Last seen 8 November 2013 - 8 Nov 2013 à 15:57
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 10 Nov 2013 à 09:42
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 28 January 2010 Status Contributor Last seen 5 May 2022 766
10 Nov 2013 à 09:42
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)))