If you mean colour Column A whenever *any* cell in Column N is negative then
try:

=MIN($N:$N)<0

in Conditional formatting

If you mean if the the cell in the same Row in Column N is negative then
colour only the entry in Column A in that row then use:

=N1<0

If you mean if there is no value in Column N in the same Row then do not
colour Column A but otherwise colour Column A if *any* cell in Coloumn N is
negative then in Condition 1 use:

=OR(N1="",N1=0)

and select no Color and in Condition 2 use:

=OR(N1="",N1=0)

If you mean something different then post back.

--
HTH

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


Replace @mailinator.com with @tiscali.co.uk


"computexcel" wrote in message
...
I lost a formula I had for conditional formatting.
This is what it did:
Color all names RED in column A if column N values goes under 0 (zero).
A=names
N=numbers
Also if there is no values(empty)
in column N, name in column A will remain the same.
Hope someone help me ( is a short one) however at this point any formula
will do.
THANKS.