View Single Post
 
Old 01-17-2024, 08:34 AM
George24 George24 is offline Windows 11 Office 2021
Novice
 
Join Date: Jan 2024
Posts: 6
George24 is on a distinguished road
Default Macro to shade empty cells in table with pattern

Hi,


I am looking for assistance in creating a macro that will shade empty cells in the second table of my document with the pattern "Lt Up Diagonal" and color adjusting automatically. My table has 5 columns and 29 rows (rows not fixed).

I should also note that I have a macro that will completely remove rows with empty 3, 4 and 5 cells. I tried another macro from a thread I found here, but I'm struggling with adjusting it to my needs.


Below are previews of what I have (left) vs. what I want to achieve (right).
Attached Images
File Type: jpg now.JPG (23.5 KB, 10 views)
File Type: jpg want.JPG (34.8 KB, 10 views)
Reply With Quote