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.
Solved! Go to Solution.
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"?
Can you color only a single cell?
Thank you so much for your immediate support, Much appreciated
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
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