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

Thanks, this is as close as I have been able to get to what I need. Is there a way to make it recognize word Active instead of Denied?

Answer 3

Can you send me the formula, so I do not have to download anything?

Answer 4

Yes of course. Here you go.

Answer 5

This formula will look for the word "active" in Column E and will work whether there is other content in the cell or not.

=AND(B2="",IFERROR(SEARCH("active",$E2),0)>0)

NOTE: Make sure that the range you select before entering the Conditional Formatting begins in Cell B2 that is referred to in the formula or the Conditional Formatting will end up formatting the wrong rows and will not format the correct cells. Those two things must match. It appears to me that you started your selection in Row 1 (B1) rather than Row 2 (B2) in your screenshot which makes all the formatting off by up one row.