Highlighting cell based on two criteria

[randolphoralph]

I am trying to write some code that will compare two cells on a row and if they match then it will highlight another cell on the same row.

Column U-has Y, N entered
Column V-has Y, N entered
Column G-has a name entered

I need the macro to look at Column U and Column V and for example if the cell U2 has a N, and V2 has a N then the macro would highlight the cell G2 yellow.
The spreadsheet will vary on how many rows it contains. It can contain up to 5,000 rows and the macro would need to go through all the rows.
Any help would be greatly appreciated.

[NBVC]

Does it have to be a macro? Conditional Formatting is a feature that should work for you.

Select column G and go to Format|Conditional Formatting.

Select Formula Is from the 1st drop down and enter formula: =And($U1="N",$V1="N")

Click Format and choose your colour from the Pattern tab.

[randolphoralph]

How would I do the conditional formating if I need it to look at cell U2 and if there is a N, and V2 has a N or is blank then the conditional format would highlight G2 yellow?

[NBVC]

Replace with this formula:

=And($U1="N",OR($V1="N",$V1=""))

[randolphoralph]

I tried =AND($U1="N",OR($V1="N",$V1="")) and it does not appear to be working

[NBVC]

Did you select all of column G and then applied the formula in the conditional Formatting window...as I wrote it?

I tested it and it does work for both conditions.

[randolphoralph]

I did select Column G

[NBVC]

V1 can't both be "N" and also be blank...

My formula should be what you are looking for.

[randolphoralph]

You are correct V1 will only be either be N or blank...

I put in =AND($U1="N",OR($V1="N",$V1=""))

I have 2 rows that has Column U as N and Column V as blank and the forumla does not highlight the cell in Column G

I doubled checked everything with no luck

[randolphoralph]

Well I found the problem it looks like there were spaces in the cell

[NBVC]

I should make that my standard first question: "Are there extra spaces in the cell(s)?"

You don't know how many times that has been the problem driving us mad when we know a formula should be working.