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