Conditions
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 |
Conditions
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 |
Conditions
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 |
All times are GMT +1. The time now is 06:49 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com