Hello,
I've got a question about vba in excel.
I hope you can help me with this issue.
In a sheet, I want to loop through column G to check if het value is "Yes" or "No"
So for, no problem, but...
When a cell in the loop has got the value "No", I want to format that row, from column "A" to "O", not the entire row.
For example:
When in cell "G10" the value is "No", then I want to format the background for the cells "A10" tot "O10".
For the cells with the value "Yes" I also want to change the background of the cell, but different from the cells with value "No".
Thanx in advance,
Sneaky Pete