SOLVED

Help needed! Conditional formatting?

Copper 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.

 

Thanks

Yury  

 

 

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?
best response confirmed by Ryan Lange (Copper Contributor)
Solution

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

It works beautifully! Thanks for your help!!!
1 best response

Accepted Solutions
best response confirmed by Ryan Lange (Copper Contributor)
Solution

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

View solution in original post