Saturday, May 31, 2014

yogi_Formula For Cell E13 to house 'B' If D13 less than 5 -- 'S' if D13 greater than 5 -- 'G' if D13 equals +5 or -5


                                         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.


Thanks
--------------------------------------------------------------------------------------------------------------------------------------------------------