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..