How can I make cells turn a specified colour if certain criteria i
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