On September 2, 2007, Joe Conner wrote: > The dollar sign is used for absolute reference. If you want each new > cell to have an adjusted reference then delete the dollar sign and then > the reference will adjust as you seem to want. > > Ian Stephen wrote: > > Hi users > > > > I have a spreadsheet with conditional formatting references like > > > > "Condition 1" "Formula is" "If($D$2>0)" "Cell style X"
Thanks so much! I wish I'd asked the list a long time ago! IanS --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
