Previous Topic Next Topic

Format Range of Cells Based Off Another Range of Cells

Closed
JC - 14 Mar 2013 à 19:45
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 16 Mar 2013 à 11:54
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

Réponse 1 / 2
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 766
15 Mar 2013 à 07:03
try combination of IsError and Match in conditional format
Réponse 2 / 2
jpppol Posts 13 Registration date Wednesday 27 February 2013 Status Member Last seen 30 July 2013 1
15 Mar 2013 à 15:06
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
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 766
16 Mar 2013 à 11:54
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

Similar discussions

Fill adjacent cell with number from text answer
MitchP -
vcoolio -

20 responses
help me to add particular cells
mathewmunna -
mathew munna -

2 responses
Clear cell contents based on value of another cell range using VBA
Tbonekiller -
Tbonekiller -

6 responses
Excel function question
1234ah -
ac3mark -

3 responses
Name Values
brendanconlin -
TrowaD -

1 response