Hello people ... I use the following formula
= IF (G87-(TODAY ()) <20; "RENEW", "OK")
but I wish, if the result is Renew, appear blinking, or changing its color, and if it is OK to renew another different result
example
If you renew -> red and / or flashing
if ok -> BLUE
there how to do this?
use LibreOffice 3.4
---
Hey.
As in the BrOffice Calc Libber color changes are formatted as constraints and not as formulas ..
I recommend:
1 - Format styles (F11) - if you need more guidance notify
2 - Format the condition choosing the style formatted according to the expected result - Menu Format / Conditional Formatting
It is the only way that I know. Ah! this conditional formatting is not for the whole document but to the selected cell, so if there are several cells that require this condition, select them all.
I hope this helps.
Nenhum comentário:
Postar um comentário