Hey all. This seems like a great place to find some answers to my question. I am an Excel noob and have tried to use google to find what I need but it was to no avail. A friend and I are making a VERY simple version of Battleship for our multimedia class and need some help with functions/ VBA stuff. Could anyone give me a few pointers as to how I could accomplish the following?-

1. The player has a 10x10 game board on sheet 1. When they click on a certain cell in sheet 1 on the game board (ex. B2), that particular cell turns white if the corresponding cell in sheet 2 ("B2" in the ex.) equals "0" and turns red if the corresponding cell in sheet 2 equals "1".

This seems rather complicated and I cannot find a way to accomplish this. My teacher has no clue how to do it either but I would rather spend the time to accomplish this than do a half-*** project on a more generic topic, ie. football stats. Thank you very much in advance for any help you may be able to give and I hope that what I what to do is actually possible...

-Pat