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

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

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

26 responses
Excel Macro/Code help: Creating sheet for each name in column of another sheet
excelnovice2019 -
vcoolio -

21 responses
How can I publish a study that I have done on this website?
simonrasho -
Daniel_CCM -

1 response
Suggest me free plagiarism checker websites!
AliImranLive -
Ambucias -

3 responses