VBA excel condition
Posted on 2015-01-19
I want to compare one column to another column, for example if in column A I have "Toyota" then in Column D I should have "Corolla" if not then highlight both cells with red color, I want to put multiple conditions like that for different columns. how I can do that through VBA? i have thousand of records.