Conditional Formatting Range

D

Dan

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.
 
T

Tom Ogilvy

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

A Huge Conditional Format Challenge.... 2
conditional formatting, filtering then copying to another sheet 0
conditional formatting for a variable range 1
VBA Conditional Formating Using Logical Expression 4
VBA Conditional Formatting 0
Considering cells colored via conditional formatting 2
Conditional Formatting 5
Conditional Formatting 1

Top