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
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.