Conditional Formating

  • Thread starter Thread starter GMet
  • Start date Start date
G

GMet

How can I programmatically set conditional formating on
selected cells?

TIA
GMet
 
One way:

With Selection.FormatConditions
.Delete
.Add Type:=xlCellValue, _
Operator:=xlBetween, _
Formula1:="1", _
Formula2:="100"
.Item(1).Interior.ColorIndex = 3
End With
 
You must log in or register to reply here.

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

Conditional Formating 1
Excel Highlighting duplicates 0
Conditional Formatting with VBA 4
transfer data in listbox 1
Form.show error in module 3 3
Programmatically setting Conditional Formatting to a range of cells 7
counting filtered rows 2
ListBox selection 1

Back
Top