Help needed! Conditional formatting?

Conditional formatting? I would like to have rows auto highlight when -1 is entered in the Inventory Adjustment column. Is this possible?

Copper Contributor

Jan 08, 2019

I want it to automatically highlight the entire row if -1 is entered into any cell in the G or Q column.

Is this possible?

Iron Contributor

Jan 08, 2019

Hi Ryan,

yes, you can achieve this with the formula =OR($G13=-1,$Q13=-1) applied over the range =$13:$37. Please see attached.

Thanks

Yury

Ryan Lange
Copper Contributor
Jan 09, 2019
It works beautifully! Thanks for your help!!!

Forum Discussion