Hi,

Can someone help me with the below? I have a license for Office 2016. I am trying to create a spreadsheet which does the following.

1) Make G and H column = A and B column (So, whatever is typed in A and B column appears automatically in G and H column)

2) If I column is not the same as C column - then colour the cell K green. If not highlight the cell red and display text 'missing part' in column K.

Thank you for any tips you may have.



Excel Hlep.PNG