ExcelBanter - Conditional Formating

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Conditional Formating (https://www.excelbanter.com/excel-programming/309786-conditional-formating.html)

gmet

Conditional Formating

How can I programmatically set conditional formating on
selected cells?

TIA
GMet

JE McGimpsey

Conditional Formating

One way:

With Selection.FormatConditions
.Delete
.Add Type:=xlCellValue, _
Operator:=xlBetween, _
Formula1:="1", _
Formula2:="100"
.Item(1).Interior.ColorIndex = 3
End With

In article ,
"GMet" wrote:

How can I programmatically set conditional formating on
selected cells?

TIA
GMet

All times are GMT +1. The time now is 01:30 PM.