Help needed! Conditional formatting?

Ryan Lange
Occasional Contributor

Conditional formatting?


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

4 Replies

Hi Ryan,


you can click on G13, then create a formula base conditional formatting rule with the following formula:

=$G13=-1. Subsequently, in the Conditional Formatting Rules Manager you can apply the rule to the range $A$13:$J$37


A similar approach applies for the range $L$13:$T$37, where conditional formatting formula when selected Q13 would be =$Q13=-1


Please see the attached file for your reference.






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?

Hi Ryan,


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




It works beautifully! Thanks for your help!!!
Related Conversations
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
Edge insider Dev bypasses IE mode website list
HotCakeX in Enterprise on
4 Replies