Conditional Formatting based on value of another cell

[duesouth]

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

[teylyn]

Leave out the " marks

=AND(M6>"0.1",M6<"0.51") You're comparing M6 with text.

=AND(M6>0.1,M6<0.51) now M6 is compared with numbers

try it and get back if you still have problems.

cheers

[duesouth]

Perfect - thanks Teylyn!