I have one column which I want to Conditional Format to traffic light colours based on the value of another cell.

I've no problem with <= or >= a certain value - but I want to pick up values between 2 numbers and can't find a formula that works i.e. I want to format any values between 0 and 0.51 as amber/orange - I've tried:

=AND(M6>"0.1",M6<"0.51")

but it doesn't work.

Any ideas?

Many thanks in advance.

Paul