Does it have to be with VB code ? Conditional formatting (Format menu) is
far easier.

Why are so many newsgroup postings channeled through Excelforum saying "any
ideas?" by the way ?
--
HTH. Best wishes Harald
Followup to newsgroup only please

"Fraggs " skrev i melding
...
How can I make cells turn a specified colour if certain criteria is
met.

for example if,
-1015+1015 = exactly 0, Cell turns green
else if
-1015+number = anything execpt 0, Cell turns red.

Any ideas?


---
Message posted from http://www.ExcelForum.com/