Color my cells (conditional formating)

[Longdaica]

Hi all

After finishing my framework, I want to color my cell that in those condition

If Cell A1 <=80 = color green 

else if   100> cell A1 > 80 , color orange 

else Cell A1 color red

Table tool will format the every cells in a row which i don't want it.

Please help. 

[Archaeopteryx]

Hi,

Please tell me what this part of the formula means:

100> cell A1 > 80

Does this mean "if A1 is less than 100 and greater than 80"?

[Archaeopteryx]

Can you color only a single cell? 

[Sathishu1985]

Thank you so much for your immediate support, Much appreciated

[nicole95]

is there a way to do this for string values rather than numeric values? I've tried creating an IF statement of the following nature but it doesn't seem to work

IF [Outlier - Sales]= "Above" THEN "color: yellow;" ELSEIF [Outlier - Sales]= "Below" THEN "color: yellow;" ELSE "color:green;" ENDIF

[DavidElliott]

Hi - can you tell me....

1/How did you get amber? 

color:green

color:blue

color:red

...all work, but not color:amber

2/How did you get this to change the cell background color, rather than the text color?

Many thanks

David