VBA - Highlight a row if values in 2 columns meet certain criteria

[jasonleewkd]

Hello everyone! I'm trying to code out the following, but finding it difficult to

Search through the entire column M and N, and if value in column M is "Q3" and value in column N is "2014", then highlight in Green that row but only column A to DD.

For example, if M1 = "Q3" and N1 = "2014", then highlight in green A1:DD1.

Not so experienced with IF statements in VBA so any help is appreciated! Thanks.

 

[venkat1926]

if range("M1")="Q3" and range("N1")=2014 then range("A1:DD1").interior.colorindex=4

assume 2014 is a number and not text

 

[ParamRay]

.
.

You don't need VBA to achieve this.

Apply a conditional formatting rule to cells A1:DD1 with the formula:

=AND($M$1=$Q$3,$N$1=2014)