Take a look at "conditional formating". You should be
able to accomplish what you want.

Byron

-----Original Message-----
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/

.