Previous Topic Next Topic

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

Answer 1 / 1
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

Similar discussions

How to use conditional format based on text?
Leanne99 -
Mooseman -

26 responses
Highlight cell if another cell contains specific text
Abbi -
vcoolio -

1 response
Highlight cell if another cell contains any text
LvH -
LvH -

4 responses
Conditional formating - apply on more cells
Biljana -
Raj -

32 responses
one cell will turn green when the two other cells match
diestra123 -
diestra123 -

13 responses