Conditional Filter / Highlight a Row

[carl]

my data looks as so:

Product Sales Target
A 10 5
B 15 30
C 5 10

I would like to have the row highlighted that passes the following criteria:

Sales >= 10 and Sales>=Target

So in this example, only row 1 would be highlighted.

Thank you in advance

 

[Jason Morin]

Assuming columns A, B, and C with headers in row 1:

1. Select all the rows underneath the headers.
2. Go to Format > Conditional Formatting
3. Select "Formula Is" and put:
=($B2>=10)*($B2>=$C2)
4. Press the Format button and format as desired.

HTH
Jason
Atlanta, GA

 

[Myrna Larson]

For the formula you can also use

=AND($B2>=10,$B2>=$C2)

which may be more understandable for "newbies".

 

[Bob Phillips]

Aaah, but Mr G would tell you that is an unnecessary function call, and if
they don't understand, they should learn!