Automate Column Amts

  • Thread starter Thread starter acss
  • Start date Start date
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?
 
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?
 
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
 
Back
Top