Conditional Formatting with multiple AND/OR criteria

Hi there,
I need some help conditionally formatting a spreadsheet.
I need to highlight specific data within Column J based on data in four other columns.
Basically i need it to say something like:

Column J will be red if $B:$B="clean" AND $C:$C="floor" AND $G:$G is greater than or equal to 5 but less than 10 OR if $H:$H="yes"

Is this even possible?

thanks,
camdameron

OK, so now I need to expand on this.

i need an IF formula to capture the formula you gave above (thanks!) but expand upon it. see modifications below

So, IF(=OR($H2="Yes", AND( $B2= "Clean" or b2="clean2", , $C2 = "floor", $G2 >=5, $G2 < 10)) then the true function = "alert" and the false action =""
BUT i also need another true function to this where all criteria are the same, except the G column value is greater than 10.

does this make sense??

yeah. i think i am going to need to write a macro for this.
i keep running across mroe data that needs to be included so a single cell formula might not be the best.

basically what i need is to determine whether a sample is an alert or action based on different criteria.
i have attached an example so you can see that each location's area has different levels associated with action and alert, so i am unsure how to get "action" or "alert" populated in column J

can you just let me know whether i should look into writing a macro or if a formula will suffice? i think the formula will be too complicated and should probably apply to thentire worksheet.

i really appreciate all your help!

cameron

the third should be PR1
i have attached the updated...