Request Custom formating

I am having a custom formatting expression in Excel 2003 which displays "-" if the cell value is 0.
The expression I am using is the following.

_(* #,##0_);_(* (#,##0);_(* "-"??_);_(@_)

I need to change this for the following conditions
If cell value >500 then should show blank and if cell value =0 then should display "-". I am new to excel custom formating.
Appreciate the help from experts at the earliest for this.

Thanking you in Advance,
Raj

Good morning raj1234

...and welcome to the forum!!

Would you mind just posting a list of exactly what conditions your format requires and how it should display values. The problem is that conditional cell formatting can be done, but your are limited to (I think - but this seems undocumented) 3 conditions (or 4 if you are using Mac Excel), so your existing format might need slimming down. It may be that the format might be able to be squeezed out if you list what you need.

HTH

DominicB

Hi raj1234

Originally Posted by raj1234

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