GoKu
Board Regular
- Joined
- Dec 18, 2007
- Messages
- 244
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:
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?=IF((B3)=0," ",(B3)-NOW()+365)