Hi,

Am Wed, 3 Dec 2014 12:31:39 +0000 schrieb Gaura215:

Applies to $G$6:$M$16
Formula = =IF($L$16<-0.001,IF($L$160.001,0))
I want to change the colour of the applicable range to RED.

try:

Range("G6:M16").Select
Selection.FormatConditions.Add Type:=xlExpression, Formula1:= _
"=OR($L$16<-0.001,$L$160.001)"

Selection.FormatConditions(Selection.FormatConditi ons.Count).SetFirstPriority
With Selection.FormatConditions(1).Interior
.Color = 255
End With

Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional