Need help with a Excel Macro (I am a Newbie)

[theebookzoo]

Hello... Can an yone help me please?
I have two excel files that laid out exactly the same.
The two files are: MB.xls and CT.xls.
I need to check each of the columns starting at C3 in the CT file with the column C3 in the MB file, if the rate if 5% less in the CT than in the MB (in C3 cell) then keep the C3 valuie in the CT table, ELSE, take the MB C3 rate - 5% and put that in the C3 of the CT table and change the color (since it was changed). The MB table is that master so that is why I cpmpare to that file and make changes in the CT table.
Can anyone help me with this... I know this has to be easy for someone that is verse in Excel, I am just not.

Thanks!!!

 

[GlennUK]

If you want VBA, what have you tried so far? Show us any code that you've been playing with.

 

[theebookzoo]

Sure...
I think this might work, just not sure now how color is red if it is changed...

=IF(OR(CT!C3<MB!C3*5%,CT!C3>CT!C3*5%),
MB!C3,MB!C3+(MB!C3*5%))

 

[theebookzoo]

i THINK IT STRIPPED SOME STUFF OUT OF MY LAST REPLY, BELOW IS WHAT i HAVE IN THE CELL...

=IF(OR(Company!C3<macb!c3*5%,company!c3>MB!C3*5%),MB!C3,MB!C3+(MB!C3*5%))</macb!c3*5%,company!c3>