Highlighting rows with macro/function

Hi there

I'm quite new to excel and needs to solve a very specific problem. Goes like:

If column A, row i, equals "x" and column B, row i, is empty => highlight row i

I want the sequence to check all rows in the spreadsheet.


Hope you can help
\Xanthom

Highlight all the cells and with A1 active, assign the conditional formatting formula:
=AND(A1="x",B1="")
then set your format as necessary to highlight the row.

sorry, what do you mean by "with A1 active"?

thanks for the quick reply

Select A1, then press ctrl+a (select all), this will give you all the cells selected but with A1 active.

Capture.PNG

Does this look right? I cant seem to get it working - sorry for danish version of excel btw, hope it makes sense anyway

I think so, can you upload the workbook rather than a screenshot?

Mappe1.xlsx

there we go

Take a look at the example

yes! thank you. its finally working - appreciate it