Conditional Formatting

[GoKu]

Hi Everybody. Ive never used conditional formatting before and need some assisstance now. Im using the following formula to calculate the expiry date on a license system:

=IF((B3)=0," ",(B3)-NOW()+365)

Some of the calculated days before expiry is now in the negative value. How do I format the cells to show the text in Bold Red if the value is in the negative and black normal text if the value is in the positive?

 

[Andrew Poulsom]

Have you tried Cell value is Less than 0?

 

[GoKu]

Ive selected Cell Value < 0 = Bold Red to the applicable column and it works fine, bust as soon as I change the date value B3 to a present date e.g Today(), the format condiction of the cell stays Bold Red and does not change to Black Normal.

 

[Andrew Poulsom]

Try changing your formula to:

=IF(B3=0," ",B3-NOW()+365)

 

[GoKu]

100%, Thnk you very much!!!! Just 4 interest sake what is the difference between the way i had the formula and the way you gave the formula?