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)