Forum Discussion

Quackenbush74123's avatar
Quackenbush74123
Copper Contributor
Sep 15, 2022

date range fill

Hello everyone,

 

My organizations computers are very "finicky" with Macros. Somehow I am the only one within my organizations that can use Macros, so im trying to find a fix for my solution without macros if possible, so others can use the excel doc also on their computer. 

 

I have attached a tracker. In columns E and F I will be putting date ranges (to-from). To the right is a visual calendar which I would like to have color filled blocks appear based off that date range. For example, 9/25/2022-10/15/2022 blocks will be filled in for that row when those dates are entered. Any ideas how I can make this happen?