Conditional Formatting a range of percentages

Hi all,

I want to set up conditional formatting rules with a green/yellow/red color scale. Logic I want it to follow is below:

if cell value = 0 to 10 % turn cell RED
If cell value = 10 to 20% turn cell YELLOW
if cell value = 20+ % turn cell GREEN

Then also the same but negative

i.e. if cell value = 0 to -10% RED
if cell value = -10 to -20% YELLOW
if cell value = -20%+ GREEN

Thanks for your help

Try this:

1.RED = (A1<>"")*(ABS(A1)<0.1)

2.YELLOW=(ABS(A1)>=0.1)*(ABS(A1)<0.2)

3. GREEN =ABS(A1)>=0.2