change format

[tpkelley_no]

I am looking for a way for VBA to look at column “D” and find the first five numbers from the left that equal 10210 (altus). And then look at column “B” and see if the number from the left equal 10700, 10800 and 10850. Then turn the cell numbers red if they are equal.
Example:

Name	Names 2
10705	10210
10707	10210
10700	10210
10850	10210
10700	10211

 

[Joe4]

No need for VBA. This can be done pretty easily with Conditional Formatting.

Select cells B2 down to the end of your data.
Then, go to Conditional Formatting, select New Rule, then "Use a formula to determine which cells to format", and enter this formula:

=AND(D2=10210,OR(B2=10700,B2=10800,B2=10850))

then click on the Format button, go to the Font tab, and select your red Font color.

Here is the result:

If you really want VBA, you can turn on the Macro Recorder, and apply these Conditional Formatting steps.
Then you will have the VBA code that does this.