Forum Discussion
Ryan Lange
Jan 08, 2019Copper 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?
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
- Yury TokarevSteel 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
- Ryan LangeCopper ContributorI want it to automatically highlight the entire row if -1 is entered into any cell in the G or Q column.
Is this possible?- Yury TokarevSteel Contributor
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