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)
Related
- VBA - Conditional formatting- Apply color to last column
- Conditional Formatting: Font color for entire column based on another column ✓ - Forum - Excel
- Excel conditional formatting applies to multiple columns ✓ - Forum - Excel
- Excel conditional formatting 5 color scale ✓ - Forum - Excel
- Excel vba conditional formatting formula multiple conditions ✓ - Forum - Excel
- Conditional formating - apply on more cells ✓ - Forum - Excel
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).