Format Range of Cells Based Off Another Range of Cells

Closed
JC - Mar 14, 2013 at 07:45 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Mar 16, 2013 at 11:54 AM
Hello,

I have a set of values in column $A. I want to format cells in columns $B:$Z to be red if any of their values are equal to any values in column $A.

I know I can use Conditional Formatting for this in a quick, short rule, but I can't figure it out.

Thank you!

2 responses

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Mar 15, 2013 at 07:03 AM
try combination of IsError and Match in conditional format
1
jpppol Posts 13 Registration date Wednesday February 27, 2013 Status Member Last seen July 30, 2013 1
Mar 15, 2013 at 03:06 PM
1. highlight the range B:Z you want to apply the conditional formatting to
2. on the home tabe, styles, select CF
3. select new rule, select value in cell is
4. select equal
5. select A1
6. select colour

and repeat it but in 5 point chose A2 and again repeat
1
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Mar 16, 2013 at 11:54 AM
You dont have to add so many condition
All you have to do is first match in A column. If there is no match, then there would be error. Otherwise you would not have any error. You can trap that to format the cell
0