Formulae for cell to merge after conditional formatting

[darylqjc]

here's the question.

From my previous thread which creates an auto formatting, start end time, timeline

I managed to draft out a workable timeline using this formuale (row 7):
=AND(COLUMN(F7)>=MATCH(INT($D$7),$1:$1,0)+HOUR($D$7)-1,COLUMN(F7)<=MATCH(INT($E$7),$1:$1,0)+HOUR($E$7)-2)

But the thing is, is it possible to merge the formatted cells?

I've attach a draft excel sheet.

[DonkeyOte]

In short, no - furthermore avoid Merging cells in Excel.

FWIW, another alternative formula for you Conditional Formatting rule might be:

Please Login or Register  to view this content.