How to make a different sheet cell show up even or odd from another sheets number?

[greenfox74]

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!!!

[NBVC]

so say the put the number in Sheet1, cell A1

then in other sheet, enter in the even cell... =IF(ISEVEN('Sheet1'!A1),"E","") format the cell font as Green.

In the other cell on the other sheet... =IF(ISODD('Sheet1'!A1),"O","") format the cell font as Red.

adjust sheetname,cell as necessary.

[greenfox74]

THANK YOU! THANK YOU! THANK YOU! I will try it right now.