Forum Discussion

Ryan Lange's avatar
Ryan Lange
Copper Contributor
Jan 08, 2019

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?

  • Yury Tokarev's avatar
    Yury Tokarev
    Steel Contributor

    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  

     

     

Resources