Conditional Formatting

[ccameron]

Hi Guy's,
I am trying to use conditional formatting to highlight rows depending on values all are based on single values except 1, I need to put in 2 criteria and cant seem to get it to work. I need it to look for $I2 = >100 & $J2 = "Yes", if it meets that criteria it will highlight blue but i cant get it to work. Can someone please help?
Thankyou.

 

[jeffreybrown]

Try...

=AND($I2>=100,$J2="Yes")

 

[ccameron]

Thanks Jefferey

 

[jeffreybrown]

You're welcome

 

[rudfaden]

1. Select the area you would like for format
2. In conditional formatting click "manage new rules"
3. Add new rule
4. From the drop down menu select classic
5. form the new drop down menu select "choose formula to determin which cells to format
6. Enter =AND($I2>100;$J2="Yes")
7. Under "format with" select the color you prefer
8. click ok