Hi All,
After searching the Internet, not finding a solution, I hope one of you experts are able to help me.
My Challenge:
I have a worksheet containing a roadmap for project launches. The roadmap is a mix of "blank" and nonblank cells (D5:AE17), meaning all cells have a formula in it. Whether it is a "blank" cell or not, is determined by input from another worksheet. When updating this Input-Worksheet e.g. changing a launch date, the visual roadmap is also changing.
Depending on the project status, the borders around the cell is colored red, yellow or green with conditional formatting. This works as it should (the colors are not correct on below picture).
What I would like to, is to make the borders thicker (as you can see below, the colored borders are thicker than the black ones) - Is this possible?
I have tried with a Change_Event, but must admit that my VBA skills are not developed enough yet
/Skovgaard
After searching the Internet, not finding a solution, I hope one of you experts are able to help me.
My Challenge:
I have a worksheet containing a roadmap for project launches. The roadmap is a mix of "blank" and nonblank cells (D5:AE17), meaning all cells have a formula in it. Whether it is a "blank" cell or not, is determined by input from another worksheet. When updating this Input-Worksheet e.g. changing a launch date, the visual roadmap is also changing.
Depending on the project status, the borders around the cell is colored red, yellow or green with conditional formatting. This works as it should (the colors are not correct on below picture).
What I would like to, is to make the borders thicker (as you can see below, the colored borders are thicker than the black ones) - Is this possible?
I have tried with a Change_Event, but must admit that my VBA skills are not developed enough yet
/Skovgaard