VBA - Conditional formatting- Apply color to last column

April 2017



Issue


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?

Solution


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


Published by aakai1056. Latest update on July 26, 2011 at 06:52 AM by aakai1056.
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).