VBA - Conditional formatting- Apply color to last column

October 2016


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)

Related :

This document entitled « VBA - Conditional formatting- Apply color to last column » from CCM (ccm.net) is made available under the Creative Commons license. You can copy, modify copies of this page, under the conditions stipulated by the license, as this note appears clearly.