I have the following formula in a cell
It works just fine. Depending on cell D8 the cell will say OK or Change. If the Cell shows “OK” I would like the cell background to be Green. If the cell shows “Change” I would like the cell background to be Red.
I have tied doing this with in the formula and I can not get it to work. I have also tried it using conditional formatting and I can not get that to work either.
I do have two Styles setup one “Red” and one “Green” where the cell background is the respective color. I just can not figure it out. Any help would be grateful.