format cell problem

[Guest]

Hi,

I do not arrive to create this personalized format who is responding to
these 3 conditions

(number is displayed in percentage).

1) if < 0 the colour must be red
2) if < 10 the value must be replaced by "NS"
3) if > 10 then value must be replace by "NS"

the only think have found is :

[<+10]"NS";[Red]-0,0%;0,0%

with this format steps1,3 are ok but impossible to integrate step 2
is anybody can help me !! it's important for me..
thanks in advance

Alex

 

[JE McGimpsey]

One way:

[Red][<=0]0.0%;"NS"

Note that you didn't specify what should happen if the cell is equal to
10.

 

[JE McGimpsey]

Note, the "." should be replaced by a "," for your version.