Conditional Highlight: IF Column A is 12345 AND Column B is Range of 50-100

[ake117]

Hi, I am totally new to VBA. I am one of girls who can't code. =( I am so glad that I found this website. It has a lot of valuable information. I spend a whole day going through a lot of posts on this website to figure out how to write codes for a simple(?) task. (I thought I was simple until I was trying to do it myself)

The task is;

Column A Column B
[TABLE="width: 149"]
<colgroup><col><col></colgroup><tbody>[TR]
[TD]2917011 [/TD]
[TD]179[/TD]
[/TR]
[TR]
[TD]1873843[/TD]
[TD]65[/TD]
[/TR]
[TR]
[TD]1867902[/TD]
[TD]29[/TD]
[/TR]
[TR]
[TD]2061034[/TD]
[TD]5[/TD]
[/TR]
[TR]
[TD]1299908[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]1215847[/TD]
[TD]56[/TD]
[/TR]
[TR]
[TD]1993336[/TD]
[TD]4[/TD]
[/TR]
</tbody>[/TABLE]

I have an extensive raw data file with over 4000 rows. I want to highlight a entire row if column A is certain number (ex. 2917011) AND column B is outside of range (ex. 75-125). The problem is that different monthly reports consist of all numbers in different orders. I need codes that works universally on different reports.

I would greatly appreciate any help.
Thank you in advance.

 

[FDibbins]

Perhaps this?

=and(A1=2917011,OR(B1<75,B1>125))

 

[ake117]

Thank you FDibbins for the reply.

However,

=and(A1=2917011,OR(B1<75,B1>125))

This will only work with one report. The same value "2917011" will be in random number (could be A1 or A2 --- or A4000) on column A in different reports. I think this is why I cannot find the simple solution for it. I need a universal one that will work for all of the reports.

 

[FDibbins]

Thank you FDibbins for the reply.

However,

=and(A1=2917011,OR(B1<75,B1>125))

This will only work with one report. The same value "2917011" will be in random number (could be A1 or A2 --- or A4000) on column A in different reports. I think this is why I cannot find the simple solution for it. I need a universal one that will work for all of the reports.

Then reference the cell that the value is in...
=and(A1=cell-containing-value,OR(B1<75,B1>125))