I am trying to run a macro that would go through my data and change the background color of a cell that has no value in it. Here is kinda what I am trying to do:
If cell C2 = "yes" and E2= null, then set cell color to RGB (0,255,0)
The macro should run down each column of data, going up to 20 columns. I don't have a defined range because my data sets vary in length. My experience with VB is very limited. Any help with the code is appreciated.