I am trying to make conditions for each cell i.e.
=$A$1<0
Take that and drag it down so I don't have to enter
=$A$2<0
=$A$3<0
and so on.

Thanks
John

If you mean conditional formatformula is:

Select all the cells first then FormatCFFormula is: =A1<0

Do not enter the $ signs


Gord Dibben MS Excel MVP


On Tue, 19 Sep 2006 18:43:01 -0700, Fanntheman
wrote:

I am trying to make conditions for each cell i.e.
=$A$1<0
Take that and drag it down so I don't have to enter
=$A$2<0
=$A$3<0
and so on.

Thanks
John

Try this and drag down:

=$A1<0

Biff

"Fanntheman" wrote in message
...
I am trying to make conditions for each cell i.e.
=$A$1<0
Take that and drag it down so I don't have to enter
=$A$2<0
=$A$3<0
and so on.

Thanks
John