Need to identify each row in table where 3 cells meet expected criteria

[ewfnsrq]

Hello Everyone,

I'm new to the forum, in fact this is my first post. Of course I'm bringing a problem, I've been unable to solve on my own. Here is the problem that is getting the best of me.

I need to analyze the data under Jan, Feb, and Mar by row. The goal is to identify all rows that contain a value greater than 2 for all three months.

Rows 3,8,11,14,16 in the example meet this standard.

One of my weekly reports contain about 75 thousand rows of data that will look somewhat like the example I have provided. Oh yes, the report comes with some blank cells in the table, but I could replace those blanks with zero's if necessary.

Thank you for any assistance you can provide.

[benishiryo]

hi ewfnsrq, welcome to the forum. to do a formula, you can try this in A2:
=IF(AND(B2>2,C2>2,D2>2),"xx","")

to do a conditional formatting that highlights the row, select B2:D18 and press ALT + O + D, then do a formula as such
=AND($B2>2,$C2>2,$D2>2)

[ewfnsrq]

Thank you benishiryo! I appreciate your help very much!