Syntax for IF statement in Conditional Formatting

Question

I would like to know if the following can be achieved:

Cell F4: =IF(C4>=F3 && C4<M3) = TRUE

When returned True I will conditionally format the cell with a background colour.

I am just unsure of how to write the formula.

Answer 1

Please try =AND(C4>=F3,C4<M3)