What I have is a number of books made up with statistics I have hand typed each with no formulas added. I desperately need to automate it. If i could see a formula made for what i need i believe i could do what i need. Part of what i am looking to do is when i put a number in a cell of sheet one, have it reflect it as a capital green E for even in a cell of another sheet, or if it is an odd number put a capital red O in a different cell. If that makes sense. I'm not sure if this can be done with a formula or i need to make a macro. Which either way, I'm lost. If i could actually see the formula written out, I believe i could take it from there. I know how to choose what cells to pick from and to go to, just can't figure out the actual writing of what i need to do.

Thanks a bunch in advance!!!