Automate Column Amts

[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?

 

[Mike H]

In F1

=E1 and drag down

Whatever is entered into e1 will be mirrored in F1

 

[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?

 

[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