Hi,
this Excel model I am using is working pretty nicely, however, it is not updating like I want. Whenever I select a predefined text in a cell in column C, the cell is suppose to change color depending on what I choose. For example when the cell says "Not started" it should turn red. People have advised me to do conditional formatting, however, I find that it doesn't work after I update the model. So, I have to use VBA.
The code I use is:
It works, but just not automatically.
Does anybody know what I am talking about and could help me out?
Thanks
Even
this Excel model I am using is working pretty nicely, however, it is not updating like I want. Whenever I select a predefined text in a cell in column C, the cell is suppose to change color depending on what I choose. For example when the cell says "Not started" it should turn red. People have advised me to do conditional formatting, however, I find that it doesn't work after I update the model. So, I have to use VBA.
The code I use is:
VBA Code:
For i = 1 To lr
If Cells(i, "C") = "Not started" Then
Cells(i, "C").Font.Color = vbBlack
Cells(i, "C").Interior.Color = 10329075
End If
It works, but just not automatically.
Does anybody know what I am talking about and could help me out?
Thanks
Even