Conditional Formatting Range

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Back
Top