Listview specific rows conditional formatting

[djemy1975]

Dear friends,

Is it possible to format rows in listview and sheet according to status "Etat" (column 47 in my 3 sheets) value: I need a conditional formatting like this:
1- When Column 47 value is "clôturé" ,I want the whole row in my listview becomes red.
2- When Column 47 value is "en cours" ,I want the whole row in my listview becomes green.

Is this approach can be done?

Waiting for your reply.Thanks in advance,

[djemy1975]

Dear friends,

Is it possible to format rows in listview and sheet according to status "Etat" (column 47 in my 3 sheets) value: I need a conditional formatting like this:
1- When Column 47 value is "clôturé" ,I want the whole row in my listview becomes red.
2- When Column 47 value is "en cours" ,I want the whole row in my listview becomes green.

Is this approach can be done?

Waiting for your reply.Thanks in advance,

Sorry I moved it to EXCEL HELP