Formatting across multiple columns

[generalgort]

Hi Guys,

My question is difficult to explain and I have just realised that I can't post attachments or images on the forum, is there any way around this, as without a sample spreadsheet I don't know if I can get my question across clearly

Phil

 

[VoG]

Try using Excel Jeanie to post a screenshot http://www.excel-jeanie-html.de/html/hlp_schnell_en.php

 

[generalgort]

Thanks VoG, here goes:

Excel Workbook
	B	C	D	E	F	G	H	I
2	Number	Entry Time	Exit Time	07:00	08:00	09:00	10:00	11:00
3	1	07:15	10:20	Y
4	2	08:10	11:25		Y
5	3	08:00	09:15		Y
6	4
7	5
8
9
Sheet1

Okaaay, I take it that is what you were on about.

Anyway, my question:

In my sample spreadsheet, I have used the formula:

=IF($C3>=E$2,IF($C3<F$2,"Y",0),0)

in E3 and filled to I9, this along with the conditional formatting fills the cells that are defined by the 'Entry Time' ie C3 is 07:15, colouring E3 yellow etc.

What I would like to achieve is to have the yellow fill for all the cells defined from the 'Entry Time' to the 'Exit Time' so for 'Number' 1 the cells E3 to H3 would be filled.

Just for good measure, is it possible to have the 'Entry Time' and 'Exit Time' displayed in the relevant cells?

I hope that come across clear enough,

Phil.