conditional formatting

  • Thread starter Thread starter S
  • Start date Start date
S

S

how do I write in conditional formatting (assuming its possible)

If less than 0 (ie a minus figure) then 0

Meaning if 2 then insert 2
If -3 then insert 0

thanks
 
If you mean when entering data in a cell then you could fomat, (not
conditional formatting), as "[<0] "0";General" (without the quotes).
However, this will only look like a zero, the cell will still contain the
negative number.

If you mean as a result of a formula then try:

=IF(Your formula < 0, 0, Your formula)

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk
 
Hi,

You don't need conditional formatting, just choose Format, Cells, Number
tab, Custom and replace the content of the Type line with something of the
form:
0;"0";0
 
Thanks Sandy that done the trick.

--

Sandy Mann said:
If you mean when entering data in a cell then you could fomat, (not
conditional formatting), as "[<0] "0";General" (without the quotes).
However, this will only look like a zero, the cell will still contain the
negative number.

If you mean as a result of a formula then try:

=IF(Your formula < 0, 0, Your formula)

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk


S said:
how do I write in conditional formatting (assuming its possible)

If less than 0 (ie a minus figure) then 0

Meaning if 2 then insert 2
If -3 then insert 0

thanks
Click to expand...
Click to expand...
 
Back
Top