Change cell color

[Johan]

How do i write a macro or VBA program that will change the color of a cell
based on set conditions?

eg. if the cell value <20 then change the color to red.

 

[Jacob Skaria]

Try the below

With Selection
.FormatConditions.Delete
.FormatConditions.Add Type:=xlExpression, Formula1:= _
"=AND(RC<>"""",RC<20)"
.FormatConditions(1).Interior.ColorIndex = 3
End With

 

[Simon Lloyd]

It's not a good idea to use vba if you don't have to, Excels own buil
in conditional format function is faster and more efficient, although o
very large spreadsheets can cause a problem


How do i write a macro or VBA program that will change the color of
cel
based on set conditions

eg. if the cell value <20 then change the color to red.


--
Simon Lloyd

Regards
Simon Lloyd
'Excel Chat' (http://www.thecodecage.com/forumz/chat.php)