Forum Discussion
IF/THEN FORMATTING
Background: I have a column (A) formatted so that it 'fills' a cell with a color based on a numerical range input by me, three ranges used. I have a column (B) that needs a value from columns (C, D, ...
(1) To get conditional formmatted color need user-defined function.
Function MyColor(rng As Range)
MyColor = rng.Cells.Interior.Color
End Function
(2) Then "SWTICH" VALUE or UserFunction(CELL)
B2 = SWTICH( MyColor(A2), EnumColor1, C, EnumColor2, D, EnumColor3, E)
Function MyColor(rng As Range)
MyColor = rng.Cells.Interior.Color
End Function
(2) Then "SWTICH" VALUE or UserFunction(CELL)
B2 = SWTICH( MyColor(A2), EnumColor1, C, EnumColor2, D, EnumColor3, E)