conditional formatting formula to search a range of cells

[drfarmkid]

I have a spreadsheet where the data in the columns is grouped into groups of 2-12 columns separated by columns filled with |. I would like to apply a conditional formatting forumula that would search the row to the left and right to find the boundaries of the group (delineated by |) and apply formatting if certain conditions are met (if all of the columns in that group have data above a certain level).

I have attached a small portion of the spreadsheet to show what I mean. I know how to make the decision or not whether to apply formatting, I just need help figuring out how to get the formula to look left and right to find the range.

[NBVC]

Try this:

Add the pipes ( | ) to the ends also, i.e. in AA3:AA12

Then select B3:AA12 and apply conditional format formula:

Please Login or Register  to view this content.

[drfarmkid]

Thank you; that works. I can almost understand it, but not quite yet. I'm learning quite a few useful tips and tricks, as well as understanding some of the functions better, the more I stare at it. Again, thank you.