I want to color the previous cell if the next cell has the VALUE "F".
Data must be in the one row, that’s why I got a problem with that.
Conditional formating wont work in here maybe some macro. Does anyone know hot to solve that? Thank you in advance
>Solution :
Conditional formatting worked for me. A basic example is shown below …
