VBA code or other solution to color cells white if they contain no data

[David77]

Hello everybody,

I am currently facing an issue. I would like to create a code that colors my cells with a complete white background and no borders if they contain no data (numbers, letters, signs or anything else).

Please see the following snip:

For the blank cells from Cell A135-D135 and below, I would thus like for them to be automatically turned into the same white background as is seen to the right of them because they have no data in their cells.

Is there any way in which I can do this through a VBA code for example?

I would greatly appreciate any assistance I can get! Thank you so much everybody

Best regards,
David

 

[David77]

Unfortunately, Conditional Formatting does not affect the default gridlines.

I actually found out how to do it through conditional formatting to affect the gridlines.

However, I don't know how to enter a code that says basically:

If the value of the cells taken from the other sheet is not blank --> create green gridlines/borders
If the value of the cells taken from the other sheet is blank --> create white gridlines/borders and background

How would I do this?

 

[Fluff]

Please answer my question in post#10

 

[David77]

Please answer my question in post#10

This is another topic that builds on the previous topic (I couldnt edit or delete the other topic I created, so please feel free to remove it if you can do so). I left out a lot of information and found a lot of new issues regarding my gridlines and conditional formatting and VBA coding, which is why I found it necessary to create this topic.

 

[Fluff]

Ok, I have locked your previous thread.