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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA set thick borders around non empty cells in range 0
copy cell color but not conditional format equations 2
loop until empty row and column problem (format cells until the lastrow and column in a report) 2
Macro to loop through a named range, ignoring empty cells 1
MACRO RUN random percentage and copy of column values 1
Moving a bunch of data 1
Macro to check if cells ("G13:J13") have values in them 6
subtracting a range from another range and getting a range result 4

Back
Top