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 …