Martin H Tayler
New Member
Hello,
I'm a retired data analyst who likes to dabble in writing code to keep my mind active! Love the dashboards and the other information that Chandoo has provided for free. Thank You. In future I will use your site as a great reference source and perhaps participate in some of the classes.....if I get some time.
My question relates to the modification of the Vacation Tracker Dashboard, particularly with the conditional formatting for colouration of leave types. A simple question given that I understand all of the functions for the rest of the dashboard after playing around with it. In this regard I have added many other leave types in the defined table and altered the display so it shows the new types of leave on the dashboard with the leave type name and the colour I have chosen.
However, when I added the formula =G13=5 and the range =$G$13:$CT$62 with the appropriate colour it does not display in the grid, so I guess the formula is wrong.
I have been wracking my brain to what I am doing wrong but can't get a solution so could someone please enlighten me!
Thank you.
I'm a retired data analyst who likes to dabble in writing code to keep my mind active! Love the dashboards and the other information that Chandoo has provided for free. Thank You. In future I will use your site as a great reference source and perhaps participate in some of the classes.....if I get some time.
My question relates to the modification of the Vacation Tracker Dashboard, particularly with the conditional formatting for colouration of leave types. A simple question given that I understand all of the functions for the rest of the dashboard after playing around with it. In this regard I have added many other leave types in the defined table and altered the display so it shows the new types of leave on the dashboard with the leave type name and the colour I have chosen.
However, when I added the formula =G13=5 and the range =$G$13:$CT$62 with the appropriate colour it does not display in the grid, so I guess the formula is wrong.
I have been wracking my brain to what I am doing wrong but can't get a solution so could someone please enlighten me!
Thank you.