quinta-feira, 5 de abril de 2012

Formula = IF () with custom results (Open Office)

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