multiple Formula in Conditional Formatting

[Saneesh]

Hi All,

i have a scenario where i have a scenario that i have to apply two conditions for a cell:

Let say i want to do it for Column A1

1. A1<10 if yes cell interior color should change to Red
2.A1>=10 if yes cell interior color should change to Green

can i do this in just one condition?

Thanks in advance

 

[Willem Gerritsen]

You could color all cells red (non conditional), and then use conditional formatting to color values >=10 Green.

 

[Saneesh]

Hi Willem,
Thanks for the update.

But in my case that is not allowed as all cell should be in white.

can u help me in executing my below code:

Code:
With ThisWorkbook.Sheets("27-Sep").Range("g7:g10") .FormatConditions.Add Type:=xlExpression, Formula1:="=g7<$g$3", Formula2:="=g7>=$g$3"
.FormatConditions(1).Formula1.Interior.ColorIndex = 3
.FormatConditions(2).Formula2.Interior.ColorIndex = 46
End With
any way to execute this?