Writing a macro that compares values from two or more columns
Posted by Amit on January 25, 2002 9:41 AM
I have a huge excel file. I want to write a macro in VBA which compares the values of two columns row by row. For eg. There are two columns K and M. Either of the column can have any value. Now i want to compare the value of K and M with another column Z. To explain this point more ... lets say K for row 10 has a value "Closed" and M for that row has "Open" Now for this row i want to see if Z has either of the values (Closed or Open). If Z for row 10 has either of the values then the macro should do nothing otherwise the macro should highlight Z with a background color.
This has to be done for the entire excel file.
Could anyone help me with this.