If you simply want to show negative numbers as red and positive numbers as
blue then conditional formatting will do the trick.

select cell and click Format Conditional formatting and the rest is fairly
intuative.

If the cell contains a - or + sign as text then likewise conditional format
will work but use 'if cell is equal to "-" or "+"

"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