Hi Zafar,

glad the last suggestion worked for you.

As regards the colouring of cells, highlight all the cells and click
the colour icon to select Blue. Then use Format | Cells | Number (tab)
and select Custom at the bottom of the list. In the panel under Type
enter this:

0;[Red]-0

and click OK. This will give you blue numbers if they are +ve and red
numbers if they are -ve.

Hope this helps.

Pete

vlook fomula wrote:

can i use any formula for colour
example i have a some col. in a work sheet one of them have different
figures like with + sign and - sign. i want to show all - sign with colour
red and +sign with blue
i will be gratefull if any body help me and i would like to thanks pete too
to solve my previous problem.

regards

zafar