VBA - Conditional formatting- Apply color to last column

I want to do a conditional formatting but I am facing the following problem:

On the same line (5 columns), is it possible to display in red (for example) the left-most cell according to the criteria of the 4 other cells of the line?
I will put in the conditional formatting, a condition:

1 - If criteria = Text (Cr1, Cr2, Cr3, Cr4)
= AND (B4 = "Cr1"; C4 = "Cr2", D4 = "Cr3", E4 = "Cr4")
2 - If = criteria numbers (1,2,3,4)
= AND (B4 = 1, 2 = C4, D4 = 3, E4 = 4)
Ask a question
CCM is a leading international tech website. Our content is written in collaboration with IT experts, under the direction of Jean-François Pillou, founder of CCM.net. CCM reaches more than 50 million unique visitors per month and is available in 11 languages.
This document, titled « VBA - Conditional formatting- Apply color to last column », is available under the Creative Commons license. Any copy, reuse, or modification of the content should be sufficiently credited to CCM (ccm.net).