Forum Discussion
Solved
How to highlight the last cell based on other column value
Hello, I want to highlight the last value in column B based on the name of the company and if the last value for the company is 0 or empty, no highlight will be done. I tried to use a formula in ...
Does this conditional formatting formula do what you want?
=AND(ISERROR(MATCH($A2,$A3:$A10000,0)),$B2>0)
Does this conditional formatting formula do what you want?
=AND(ISERROR(MATCH($A2,$A3:$A10000,0)),$B2>0)