Select any row for A column if any of 3 columns B,C or D are lower than 10

[Problinker]

Hi,

I want to select all row of column A (names of products) that have a concetration less to 10 in any of B (horses), C(cows), D(elephants).

I mean, if concentration of product XXX is less than 10 in horses but not in cows or elephants I want to select it. Same if the condition appear in two or 3 of the animals.

Could anyone help me?

Many thanks

Andrea

[Paul]

Assuming your product names are in A2:Ax, and concentrations in B2:Dx (x = last row of data), you can use Conditional Formatting to highlight the products in column A where a value below 10 exists in B:D for that row.

Select A2:Ax, then click Conditional Formatting > New Rule... > Use a formula to determine which cells to format
In the formula box below, type: =AND(MIN(B2:D2)<10,COUNT(B2:D2)>0)
Click the Format button to set the Fill/Font colors, etc., then click OK a couple times to return to your worksheet.

The formula checks if the minimum value in columns B:D for each row is below 10 AND if there is at least one value entered in B:D for that row. (If it didn't check for at least one value, the condition would be true with three blank cells.) Note that the row value in the CF formula will auto-adjust and apply to the individual rows.