• 412K Members
• 7,506 Online
• 468K Conversations
SOLVED

## Help needed! Conditional formatting?

Occasional Contributor

# 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?

4 Replies

# Re: Help needed! Conditional formatting?

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

Thanks

Yury

# Re: Help needed! Conditional formatting?

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?
Solution

# Re: Help needed! Conditional formatting?

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

# Re: Help needed! Conditional formatting?

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