Help with a Formula: IF less or more than 0

[Capy_Uther]

I need a formula on the cell "J6", if "I6">0, Color the whole cell RED with the Text "Vencido" or "I6"<0, Color the whole cell GREEN with the Text "Corriente"

Thanks.

 

[dreid1011]

This would be a combination of a formula in cell J6 and two conditional format rules applied to cell J6.

The formula would look like this:

=IF(I6>0,"Vencido","Corriente")

Then, you would apply the following CF rules to J6 as well:

Rule 1:

=$I$6>0

Format: Fill color Red

Rule 2:

=$I$6<0

Format: Fill color Green

Can I6 ever equal 0?