SOLVED

Help needed! Conditional formatting?

Highlighted
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
Highlighted

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

Highlighted

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

Highlighted

Re: Help needed! Conditional formatting?

It works beautifully! Thanks for your help!!!