Hi,
You may try conditional formating from Format Menu
First give conditional formating to first cell of your data or range or
A1 cell
If Cell Value is less than 1 format it in different colour back ground,
less fort size, colour display etc
Then copy this conditional formatted cell to all your data or entire
worksheet as you please


--
gandhi318Posted from - http://www.officehelp.in