Guys,
I know this has been touched on many times, but I have trawled the site unable to find a solution. I need more than 3 conditions within a conditional format - hence am using a bit of code in the sheet. I need to colour the row when a condition in a cell in the same row is met (through a validation list)
Please can someone help with the code, I am not a programmer so be kind.
I have used the following and tried to adapt it with my limited vb understanding, but it only changes the colour of the cell - how do I do the row?
For Each c In Worksheets("Issues Log").Range("M6:M2000")
If c.Value = "a" Then c.Interior.ColorIndex = 1
If c.Value = "b" Then c.Interior.ColorIndex = 2
If c.Value = "c" Then c.Interior.ColorIndex = 3
If c.Value = "d" Then c.Interior.ColorIndex = 4
If c.Value = "e" Then c.Interior.ColorIndex = 5
If c.Value = "f" Then c.Interior.ColorIndex = 6
Next c
Thanks in advance
I know this has been touched on many times, but I have trawled the site unable to find a solution. I need more than 3 conditions within a conditional format - hence am using a bit of code in the sheet. I need to colour the row when a condition in a cell in the same row is met (through a validation list)
Please can someone help with the code, I am not a programmer so be kind.
I have used the following and tried to adapt it with my limited vb understanding, but it only changes the colour of the cell - how do I do the row?
For Each c In Worksheets("Issues Log").Range("M6:M2000")
If c.Value = "a" Then c.Interior.ColorIndex = 1
If c.Value = "b" Then c.Interior.ColorIndex = 2
If c.Value = "c" Then c.Interior.ColorIndex = 3
If c.Value = "d" Then c.Interior.ColorIndex = 4
If c.Value = "e" Then c.Interior.ColorIndex = 5
If c.Value = "f" Then c.Interior.ColorIndex = 6
Next c
Thanks in advance