Hi all After finishing my framework, I want to color my cell that in those condition If Cell A1 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.

Please find the attached screenshot where I need to select the colored cells along with all the columns in the excel. Your immediate assistance would be much appreciated.

Thanks

Sathish

sumasha3@ford.com

colored cells.docx

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

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703