Can i automatically format cells to be a certain color if the val.
 

Can i format a cell to be red or green depending if the value is negative or
positive.

ya u can use conditional formatting for this purpose!

--
Hope it Helps!
Jim
India




"jack442" wrote in message
...
Can i format a cell to be red or green depending if the value is negative
or
positive.

Hi Jack,
Try Formatting, Conditional Formatting


"jack442" wrote:

Can i format a cell to be red or green depending if the value is negative or
positive.