In the spreadsheet I want to automatically highlight row once a particular cell value is entered.
I've configured H column with list values: [valid,invalid] in Data→Validity.
The idea is to apply custom hlt-invalid-bg style to row where "invalid" value is set in the cell H.
I'd like to learn how it can be done using Format→Conditional Formatting or using any other method.
In Condition 1 select "Formula is" and input the Formula
($H1="invalid")
In Apply Style select "New Style...". The Dialog "Cell Style" is shown.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With