Conditional background if a cell in the range is empty

  • Thread starter Thread starter Anika V. Bristalli
  • Start date Start date
A

Anika V. Bristalli

My apologies if this has already been addressed, but I could not quite
find the exact answer in the previous topics. I am trying to create a
macro that does the following:

* There is a user-selected range (R1)
* The macro goes through each cell in Column 3 of the selected range
(R1.Columns(3)), and checks if a cell is empty or not. If the cell is
empty, then the macro colors this cell plus the seven adjacent cells
to the right of it in grey.
* The macro terminates when it reaches the end of the selected range
R1.

I know the basic concepts, but seem to be missing something with
regards to syntax or something as I am fairly new to excel vba. So, I
would appreciate any suggestions as to how to properly code this
thing. Thank you!
 
hi,
what range would the user select? and "Any range" doesn't answer the question.
would the user select A1:AF1000 or something smaller. would the selected
range vary in size and place.

Regards
FSt1
 
Back
Top