Changing colour on changing a Data Validation List with VBA
As per the Title, I am Adding
Data Validation using a Macro but I want to also change the colour on selecting the Items in the desired column F.
Dim Target As Range
Dim LastRow As Long
LastRow = .Cells(.Rows.Count, "D").End(xlUp).Row
For Each cell In Range("C2", Range("C65536").End(xlUp))
'Set target = Range("B1:B3")
Set Target = Range(cell.Offset(0, 3), cell.Offset(LastRow, 3))
.Add xlValidateList, 1, 1, "Fixed Cost,Variable Cost"
.InCellDropdown = True
.ShowInput = True
I am getting 90 filled rows instead of 45 in the column F and 45 in Column G when I am running the same code again for the
second column G
I want to add Data Validation Items such as :1 Fixed Cost which should be in the Red Colour i.e.
Colour Index = 3
2 Variable Cost which should be in the Blue Colour i.e. Colour Index = - 4165632
The Text should have the
Horizontal Alignment= Left
Font = "Book Antiqua"
Font Size = 13
I want to get the colour change immediately on changing the Data Validation...