Highlight Data Based on Data in Another Column

[JohnYuhaschek]

I asked the wrong question

How can I Select data based on another cell in the same row?

Ex. I only want to Select data in Column C & D only if Column B = Rm2. I will be doing a find and replace after the info has been selected. I will be using this in a macro.


A B C D
1 Bob Rm1 x 0
2 Jack Rm1 x 0
3 Dean Rm2 n 0
4 John Rm2 n 0
5 Barb Rm3 x 0

[LalitPandey87]

We can select Column C & D based on Column B with the help of find method in VBA but what next.

[JohnYuhaschek]

I only need to select the data in Columns C and D where Column B equals the room number chosen.

So for this example for Rm1, I only need to Select the information in Columns C and D in rows 1 and 2.
If I needed to select Columns C and D for Rm2, I only need to Select the information in Columns C and D in rows 3 and 4.
The macro would almost work like conditional formatting where the data would be highlighted based on a condition in the row.

I hope I explained it better.

[JohnYuhaschek]

A B C D
Bob Rm1 x 0
Jack Rm1 x 0
Dean Rm2 n 0
John Rm2 n 0
Barb Rm3 x 0

I only want to select the data in Columns C and D where the Rm# in each of the rows of data = Rm1

Example:
Premise: If I wanted to select the data from Column C and D with Column B = Rm1
Solution: I would select Columns C and D in rows 1 and 2.

I'm going to replace the x in Column C with "n/a" and the 0 in Column D with "j/k"