Hi raj1234
Quote Originally Posted by raj1234 View Post
My conditions for custom formating are :
It should be having commas for 1,000 actually I need 1000 sorry for the misinfo in my thread above.
if cell value >1000 then it should show blank
if cell value =0 then it should show "-"
Negative values should show brackets.
Hmmm, as I thought I managed to get three conditions in, but Excel keeps rejecting the fourth. This custom format will show nothing for values above 1000, show a "-" for zero values and will show the figures without commas, just doesn't show () for minuses. This is what I came up with :
[>1000]"";[=0]"-";###
(you can use Ctrl+c and Ctrl+v to copy it into your format box)

Although this doesn't answer your question fully, I suppose you could handle all conditions but the greater than 1000 with cell format, and use conditional format to kick in if the value is higher than 1000 and turn the font colour the same as the background colour - ie, so it doesn't show up. Just a thought ...

HTH

DominicB