Color a few cells according to 1 cell's value

Question

I have a hourly plan where time of employees' meetings automatically appears from an other sheet. I need it to be marked with specific color according to meeting's lenght. Ex.

"A1=0,5 then A1 is blue if A1=1 then A1 and A2 is blue if A1=1,5 then A1, A2, A3 is blue and etc."

I only find info how to mark specific cell using conditional formating or VBA, but don't know how to apply formula to the whole table

Answer 1

Conditional Formatting

Select the range where you want this applied, e.g. A1:A10, or A1:J10 if you want this to work in the other columns, too.

On the Home tab select Conditional Formatting > New Rule. In the New Formatting window select Use formula to determine which cells to format. In the text box below enter this formula:

=A$1/0.5>=ROW()

Press the Format button below and in the Format Cells window select the Fill tab. Select a color and press Ok 3 times.