VBA code for If Statement

[glennjrobertson1980]

Hi,

I have a spreadsheet of information with some VBA code attached to it.

Within the spreadsheet are two columns A & B, column A will either be blank or contain "COMMS" and column B will be the same either blank or contain the value "COMMS".
I need some VBA code that will do the following.

Select the cell in column A and change the cell colour to red if column A and B both contain "COMMS" in that row. Is this possible.

Many thanks

 

[healey21]

You can achieve this with Conditional Formatting, no need for VBA.

=AND(A1="COMMS",B1="COMMS")

Then apply the Red format.