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
1	Animal 1	Animal 2	Number
2	Dog	Mole	2
3	Sheep	Cat	4
4	Dog	Cat	6
5	Goat	Sheep	8
6	Mole	Goat	22
7	Dog	Cat	44
8	Dog	Cat	33

<tbody>
</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