I want to impliment a conditional format that covers a range comparing cells
in G to the cells F example: if G26<F26 then /. ./ color index=3, g27<F27
etc. To add a twist I am trying to start at row 26 ending @ 500. I have
figured out for a single cell but duplicating for a few hundred ....gotta be
an easier way.

Range("G26:G500").Select
Selection.FormatConditions.Delete
Selection.FormatConditions.Add Type:=xlExpression,
Formula1:="=$G26<$F26"
Selection.FormatConditions(1).Interior.ColorIndex = 3

--
Regards,
Tom Ogilvy

"Dan" wrote in message
...
I want to impliment a conditional format that covers a range comparing
cells
in G to the cells F example: if G26<F26 then /. ./ color index=3, g27<F27
etc. To add a twist I am trying to start at row 26 ending @ 500. I have
figured out for a single cell but duplicating for a few hundred ....gotta
be
an easier way.

Genius Thanks Tom!!!! BTW Have any reccomendations for a VBA book??

"Tom Ogilvy" wrote:

Range("G26:G500").Select
Selection.FormatConditions.Delete
Selection.FormatConditions.Add Type:=xlExpression,
Formula1:="=$G26<$F26"
Selection.FormatConditions(1).Interior.ColorIndex = 3

--
Regards,
Tom Ogilvy

"Dan" wrote in message
...
I want to impliment a conditional format that covers a range comparing
cells
in G to the cells F example: if G26<F26 then /. ./ color index=3, g27<F27
etc. To add a twist I am trying to start at row 26 ending @ 500. I have
figured out for a single cell but duplicating for a few hundred ....gotta
be
an easier way.

http://www.j-walk.com/ss/books/index.htm
Excel Books by John Walkenbach

http://www.oaltd.co.uk/OAPage.htm#Books
Stephen Bullen's site

--
Regards,
Tom Ogilvy


"Dan" wrote in message
...
Genius Thanks Tom!!!! BTW Have any reccomendations for a VBA book??

"Tom Ogilvy" wrote:

Range("G26:G500").Select
Selection.FormatConditions.Delete
Selection.FormatConditions.Add Type:=xlExpression,
Formula1:="=$G26<$F26"
Selection.FormatConditions(1).Interior.ColorIndex = 3

--
Regards,
Tom Ogilvy

"Dan" wrote in message
...
I want to impliment a conditional format that covers a range comparing
cells
in G to the cells F example: if G26<F26 then /. ./ color index=3,
g27<F27
etc. To add a twist I am trying to start at row 26 ending @ 500. I
have
figured out for a single cell but duplicating for a few hundred
.....gotta
be
an easier way.