Conditional Formatting Google Sheets

[odonovanc]

In cells B2:B32, I want them to be highlighted if B33 is greater or equal to B35 AND then if the cell in that B2:B32 range is greater than or equal to B36.

I have apply to range of B2:B32 and custom formula is =AND(B33>=B35,B2>B36) but it is not working. It is currently highlighting all cells except B2.

Perfect world, I can copy and paste whatever the right formula is in other columns with different values. For example, C2:C2 based on C33, C35, C36 that will be different values than B.

 

[Fluff]

Try it like

=AND(B$33>=B$35,B2>B$36)