Ive searched and searched! if statement/cell color SOLVED

[TrevorEB]

Hello all!

I know im brand new so i took the time to search the forums to try and find my answer but i couldnt find anything. i hope some kind soul will take pitty on a newby and help me out.

I am trying to write an if statement to show one of two colors in a
cell. For example, if a certain value is less than X, the cell
will turn this color, otherwise the cell turns a different color. I am
trying to figure out the "then_value" and "otherwise_value" that I would
use to do something like this. Any tip would be extremely appreciated.

Thank you so much

[squenson]

TrevorEB,

Two possibilities:

1) Use conditional formatting. First create two new styles with the proper colors. Then apply conditional formatting on your cells.

2) Use the function STYLE. Again, create two styles, and in your if clauses, add the STYLE function. One example: =IF(A1=1;A1+STYLE("Green");A1+STYLE("Red"))
_________________
Help us to help you: Add [Solved] to the title of the thread if you agree with the answer
>>> Do you know the new OOo support forum http://user.services.openoffice.org/en/forum/index.php? <<<

[TrevorEB]

thanks so much for your help. nice people like you make forums so worth while.