agnesz
06-19-2008, 11:20 AM
I have a spreadsheet which aligns names to different areas. THis gets updated monthly and each time I need to reformat the whole document to highlight and border new things. Is there a way to write a macro where depending on the text in column B, that whole row ranging from col B to V would get reformatted?
To illustrate:
If Col B = "Planner" or "MPD", then all of that row should be size 8, cells in B and C should get highlighted in gray and range b through v should get a thick outline border.
If Col B = "DDP" or "GMM", then all of that row should be size 10, cells in B and C should get highlighted in gray and range b through v through get a thick outline border.
Thanks:motz2:
To illustrate:
If Col B = "Planner" or "MPD", then all of that row should be size 8, cells in B and C should get highlighted in gray and range b through v should get a thick outline border.
If Col B = "DDP" or "GMM", then all of that row should be size 10, cells in B and C should get highlighted in gray and range b through v through get a thick outline border.
Thanks:motz2: