Format Range of Cells Based Off Another Range of Cells

Closed
JC - Mar 14, 2013 at 07:45 PM
rizvisa1
Posts
4479
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 replies

rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
769
Mar 15, 2013 at 07:03 AM
try combination of IsError and Match in conditional format
1
jpppol
Posts
14
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
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
769
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