pbobadilla
09-20-2012, 01:34 PM
Hello,
I am trying to apply a background color (yellow) for any cells in the range c12:c511 if any of the cells within each row (range a:ch ) is blank then the cell in column c turns yellow. For ex: If any cell from a12:CH12 is blank, then c12 turns yellow. This would be applied to each row until c511 is reached. Is there any way to do this for all rows with VBA code instead of having to apply a specific conditional formatting through the "manage rules" section of excel. Any help would be appreciated.
Thanks,
Pablo
I am trying to apply a background color (yellow) for any cells in the range c12:c511 if any of the cells within each row (range a:ch ) is blank then the cell in column c turns yellow. For ex: If any cell from a12:CH12 is blank, then c12 turns yellow. This would be applied to each row until c511 is reached. Is there any way to do this for all rows with VBA code instead of having to apply a specific conditional formatting through the "manage rules" section of excel. Any help would be appreciated.
Thanks,
Pablo