RE: $$Excel-Macros$$ VBA Conditional Format Offset

Try the Attachement -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Daniel Sent: Thursday, July 21, 2011 9:36 PM To: excel-macros@googlegroups.com Subject: RE: $$Excel-Macros$$ VBA Conditional Format Offset Try : Sub

RE: $$Excel-Macros$$ VBA Conditional Format Offset

ine- De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De la part de Natron Envoyé : jeudi 21 juillet 2011 19:05 À : MS EXCEL AND VBA MACROS Objet : Re: $$Excel-Macros$$ VBA Conditional Format Offset Thanks Daniel that works, but I'm still trying to wrap my head around

Re: $$Excel-Macros$$ VBA Conditional Format Offset

Thanks Daniel that works, but I'm still trying to wrap my head around applying this format to various ranges on the worksheet. My data I'm comparing is in Column D and F, E and Getc all the way up to Column EK. Any pointers on skipping around with this formula? Thanks again! Natron > Try

RE: $$Excel-Macros$$ VBA Conditional Format Offset

Try : Sub ConFormatOffset() With Range([A1], Cells(Rows.Count, 1).End(xlUp)) .FormatConditions.Delete .FormatConditions.Add Type:=xlExpression, Operator:=xlGreater, _ Formula1:="=A1>B1" .FormatConditions(1).Interior.Color = RGB(255, 0, 0) End With End Su