Format Range of Cells Based Off Another Range of Cells

[Closed]
Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
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

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
try combination of IsError and Match in conditional format
1
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2821 users have said thank you to us this month

Posts
14
Registration date
Wednesday February 27, 2013
Status
Member
Last seen
July 30, 2013
1
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
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2821 users have said thank you to us this month

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
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