Excel根据其他单元格值创建“条形图”或填充一系列单元格

I want to create a automatically generated "timeline" as i fill a column with numbers. Lets say C4 gets the value of 5. Then I want D4:I4 to be either filled with a 1 (so I can use conditional formatting), or filled with a specific color. This should be the case for more than 300 rows, C4:C350. Is there a way to use normal formulas or do I need to write a macro. I need it to be as easily used as possible since a lot of people not used to work with macros should be able to use it. I want to create a automatically generated "tim