Automate Column Amts

A

acss

I have column E and F which contains dollar amounts and users need to enter
same dollar amounts in both columns. For example column E is 100 and column F
needs to be 100 as well. Is there a way to ensure both columns reflect same
amounts after entry to avoid sum errors later on?
 
A

acss

Yes. That works but it does leave a trail of zeros in the column. Is there
code or conditional formating that would change the cell color if amounts did
not match in both columns?
 
G

Gord Dibben

If you followed Mike's suggestion there would be no possiblity of amounts not
matching.

To hide the zeros until data is entered use this trapper.

In F1 enter =IF(E1="","",E1)

Drag/copy down as far as you wish.

Have users enter data ONLY in column E


Gord Dibben MS Excel MVP
 
Top