Conditional Formatting and Formula

[Tennisguuy]

I am not sure if this can be easily done but I thought I would ask.

I have a spreadsheet with values in rows B2:BI30 and some value in rows B30:BI55. If any of the values in row B30:BI30 are found in rows B2:BI2 I want the values in rows B30:BI55 to bold and turn red. If any of the values in row B31:BI31 are found in rows B3:BI3 I want the values in rows B31:BI31 to bold and turn red and so forth and so forth until row B55.

I was wondering if a formula could be done without having to do a conditional formatting for each individual rows from B30:B55

 

[FDibbins]

Your references are a bit confusing (for me, anyway), but you could probably do this with a COUNTIF() function

 

[Tennisguuy]

I used the following formula and it works

=COUNTIF(B30:AE30,B2)>=1 it applies to cell B30

Is there a way to use this or turn this formula into an array so that it applies from cells B30:B55 so I don't do a separate conditional format for cell B31, B32 etc

 

[Tennisguuy]

I got it to work. I just changed the applies to in conditional formatting to B30 to B30:B55.

 

[FDibbins]

Good stuff, glad you got it working for you