problems comparing cells in seperate columns

[jeasterly]

Hi all, I'm new to this but I can't find this specific question answered.

I have a spreadsheet that I am pulling into a workbook via macro that the data in Column B is the mfg cost : The data in Column C is the sales price.
I need the code to check if the value in C is 20% greater than the value in the corresponding B column. If it is NOT then shade the value in C yellow.

I can't use the conditional formatting since I am pulling the entire sheet in from an access query. Can anyone help. I am using Excel 2002.

Thanks so much!

 

[jeasterly]

Gosh yeah.. what flake I am...sorry. Yes, that does seem to work for me.. only one small thing.. the background is not colored.. any chance I can get that too?...

Thanks so much

 

[Norie]

Well again I would record a macro when you do it manually.

With .Item(1)
       With .Font
            .Bold = True
            .Italic = False
        End With
        .Interior.ColorIndex = 3
End With

 

[jeasterly]

Thank you - you have been sooo much help! I think I can finish this project today!

J