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

2917011	179
1873843	65
1867902	29
2061034	5
1299908	1
1215847	56
1993336	4

<colgroup><col><col></colgroup><tbody>
</tbody>

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))