conditional formatting help

[phuzz]

Hi, I need to have rows highlighted that have to meet 3 criteria in a table and was unsure what statement would be best, two have to be a specific text and one has to be above a certain number.

 

[Toadstool]

An example of your data would help but does this work? Row 7 gets highlighted.

=AND($A2="Dog",$B2="Cat",$C2 > 33)

	A	B	C
Animal 1	Animal 2	Number
Dog	Mole
Sheep	Cat
Dog	Cat
Goat	Sheep
Mole	Goat
Dog	Cat
Dog	Cat

<tbody>
[TD="align: center"]1[/TD]

[TD="align: center"]2[/TD]

[TD="align: right"]2[/TD]

[TD="align: center"]3[/TD]

[TD="align: right"]4[/TD]

[TD="align: center"]4[/TD]

[TD="align: right"]6
[/TD]

[TD="align: center"]5[/TD]

[TD="align: right"]8[/TD]

[TD="align: center"]6[/TD]

[TD="align: right"]22[/TD]

[TD="align: center"]7[/TD]

[TD="align: right"] 44 [/TD]

[TD="align: center"]8[/TD]

[TD="align: right"]33[/TD]

</tbody>

Sheet1
​

 

[phuzz]

Hey, I ran into some trouble my code seemingly has no errors but wont give me any results I took a screenshot to give you a good idea of what im trying to do https://imgur.com/a/BMXdplm

 

[Fluff]

How about
=AND($E2="Programming",$H2="Good",$G2>80000)

 

[phuzz]

sadly didn't work

 

[Fluff]

Are the columns correct, as it's difficult to tell from the image?
Also did you select B2:H94 before applying the conditional formatting?

 

[phuzz]

https://drive.google.com/file/d/1vNeQHNRjahlg5NysV5ntIpb4Wxc5Hzun/view?usp=sharing, this should help, its one table and I am selecting the column

 

[Fluff]

Select A2:F12 & use this formula
=AND($D2="Programming",$F2="Good",$E2>80000)

 

[phuzz]

This worked, thanks!

 

[Fluff]

Yuo're welcome & thanks for the feedback