Hi there, I'm wondering if there is a simple way to add conditional formatting (change/shade/highlight the colour of an entire row based on this formula below):

Assuming 2D is 1 =if(isblank(2E),1,0)

Right now, with the formula above, once data is entered into E cells, the number in D cell automatically changes. This is perfect. I would like to take it one step further and simultaneously highlight/shade the row in red so that it is CLEARLY noticeable that that item is out of stock.

Please see attached image of the spreadsheet I'm using.

Hoping this is an easy one.

PS - not an excel genius Excel2Ex.jpg