In D2 enter =IF(AND(A1<0,B1<0,C1<0,D1<0),"Buy","")
Copy across the row

OR

In D2 enter AND(A1<0,B1<0,C1<0,D1<0); copy across the row
In M5 enter =IF(COUNTIF(A2:L2,TRUE),"Buy","")

best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"j5b9721" wrote in message
...
In
A1 is "-115"
B1 is "-15" <---
C1 is "-18" <---
D1 is "Week 4"
E1 is "Price"
F1 is "-65" <---
G1 is "-25" <---
H1 is "256"
I1 is "-27"
L1 is "-56" ... and so on. (numbers are random order; mixed Positive &
Negative)


I need to have a command in "M5" to let know when "4" Negitive #'s are
logged in together, but are not in a contuinous columns, only the same
roll
with info between.
needs to be for "Conditional Formating" in M5 =IF(???,"BUY","") also needs
to be coppied and pasted for more columns.

Thanks for your time..