Google Spreadsheet Post #1656
Yogi Anand, D.Eng, P.E. ANAND Enterprises LLC -- Rochester Hills MI www.energyefficientbuild.com. May-31-2014
post by Jos P: (https://productforums.google.com/forum/#!category-topic/docs/spreadsheets/imUDfhEbSQE)
Conditional formatting adding color and letters to a cell based on another cells
I want to have cells change color and add a letter to that cell based on the value of another cell. Im using cell D13 for numeric ranging from 200 to -200, in cell E13 Im running custom formulas that change the cell E13 to red, blue or grey based on the values of D13. "=D13<5" =blue in Range E13, and "=D13>5" =red in range E13. I want to also have it put a B in the blue ones an S in the red one, grey in the -/+ 5 ones. Not sure how to add the B/S/G values to it.
Here is the a sample, the first tab, Daily closes. D13 and E13.