Adding rows to formula

[LynnyWeb]

Hi,

I am creating a spreadsheet to record staff holidays, I am using the colorfunction formula however I need it to add up 12 rows. At the moment it looks like this =colorfunction(I2,H7:AL7) but I also need it to add H27:AL27, H47:AL47, etc how do I add this into the formula?

Also I need a way for the colour function to count half days or half a cell if this is possible? Any ideas would be greatly appreciated?

Thanks

 

[Jon von der Heyden]

Duplicate, please follow this thread: http://www.mrexcel.com/forum/showthread.php?p=2680619#post2680619

Per the forum rules, threads of a duplicate nature will either be locked or deleted.