I have a worksheet with two columns and multiple rows of data in a
workbook that contains multiple sheets. Column "A" has location
information and column "B" has the owner information. I would like to
know how to automate the sheet to look at column "A" and if there is
data present then look at the corresponding cell in column "B" (i.e
"A3" then look at "B3") and if there isn't any data in "B" then change
the color.