Conditional Formatting a column with Blank cells based on text in another column.

Question

The columns titled Spfld, Dover and Boston are item numbers.

The column titled Status indicates if the item is active.

I need all blank item number cells for items where the product status is "active" to be filled with a color.

Any item with a product status denied should have no color.

Product Name	Spfld	Moline	Chicago	Product Status
Test one	45897		85331	Active
Test two				Denied
Test three		59318		Active

Answer 1

You are welcome. Did that resolve the issue ?

Answer 2

THANK YOU!!!

Answer 3

THANK YOU!!