Ask Your Question

farrinux's profile - activity

2017-02-19 14:29:12 +0100 received badge  Famous Question (source)
2016-04-08 15:30:43 +0100 commented answer Setting Cell Style either with formula or conditional Formatting!

Before I posted I had tried using the Conditional Format Manager. Seems as though it does not like text as a value. I could not get it to work. I also in my search found that one could also include it in his formula. I tried that and could not get that to work. Pierre was the first to post and his formula worked. as to being a not "correct way" to do it. There is always more than one way to skin a cat.

2016-04-05 15:21:21 +0100 received badge  Notable Question (source)
2016-04-04 13:03:29 +0100 received badge  Popular Question (source)
2016-04-04 12:36:52 +0100 received badge  Editor (source)
2016-04-04 12:32:41 +0100 commented answer Setting Cell Style either with formula or conditional Formatting!

Thank you very much. Works like a charm. I read the help section on adding the formatting in the formula. However it would not even work. While your answer is similar it works and I tried some thing very close to that, just didn't know about "T" and of course some of what needed brackets. Thanks again.

2016-04-04 12:27:33 +0100 commented answer Setting Cell Style either with formula or conditional Formatting!

D8 will always be a number. Thanks I will give this a try.

2016-04-04 12:27:20 +0100 received badge  Scholar (source)
2016-04-04 12:10:52 +0100 commented question Setting Cell Style either with formula or conditional Formatting!

Thanks for the reply. Will give it a try.

2016-04-04 08:42:35 +0100 asked a question Setting Cell Style either with formula or conditional Formatting!

Hello All,
I have the following formula in a cell

=IF(D8<60,"OK","Change")

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.