[Solved] Change color of text in a cell from input in a cell
Posted: Sat Aug 12, 2017 10:53 pm
Hello everyone,
I think it is obvious that I am new to this forum. I have been a loyal Oo user for years now and have received much help from the forums. This is my first post so please bare with me.
I have been trying to understand how to change the color of text in one cell from input in another cell. I found what I thought was the answer but for some reason I can't get it to work =IF(condition;"PASS";"FAIL")&T(STYLE(IF(condition;"Green_Style";"Red_Style"))).
I have created a spreadsheet for my business and so far it has done what I want it to do until now. What i want to do is take a name from a drop down list in one cell and apply a color change to text in another.
A11 is a list box with
D
FD
PC
MI
Van
TC
AoT
SB
SH
C11 is the cell i would like to change the color in. So if A11 is "SB" or "SH" then turn the text in C11 to green. If A11 is AoT then turn the text in C11 to Blue. Everything else will leave C11 red.
Thank you in advance for your help and understanding of a forum newbe
I think it is obvious that I am new to this forum. I have been a loyal Oo user for years now and have received much help from the forums. This is my first post so please bare with me.
I have been trying to understand how to change the color of text in one cell from input in another cell. I found what I thought was the answer but for some reason I can't get it to work =IF(condition;"PASS";"FAIL")&T(STYLE(IF(condition;"Green_Style";"Red_Style"))).
I have created a spreadsheet for my business and so far it has done what I want it to do until now. What i want to do is take a name from a drop down list in one cell and apply a color change to text in another.
A11 is a list box with
D
FD
PC
MI
Van
TC
AoT
SB
SH
C11 is the cell i would like to change the color in. So if A11 is "SB" or "SH" then turn the text in C11 to green. If A11 is AoT then turn the text in C11 to Blue. Everything else will leave C11 red.
Thank you in advance for your help and understanding of a forum newbe