Conditional formating

Question

Good day.

I have watched a number of videos related to conditional formatting and using vlookup, but either I am not understanding them or what I am looking to do it not really what I am looking for.

With reference to the below table. I need to automatically highlight "Not Applicable" in column A when in column B it says "Active"

Many thanks.

Answer 1

Select the cells in column A that are eligible for highlighting. In your example, that would be A1 through A10. On the Home tab, click on Conditional Formatting -> New Rule. Select the "Use a formula ..." Rule Type. In the formula box enter

=AND(B1="Active",A1="Not Applicable")

If necessary, change the cell references to the top row in your pair of olumns.