Highlight a range of cells

[Davers]

Hi again!!! I've received excellent help on how to return values I need! Here is the resulting spreadsheet!

November Forced Disconnects.xls
	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB
1	11/18/02	11/19/02	11/20/02	11/21/02	11/22/02	11/25/02	11/26/02	11/27/02	11/28/02	11/29/02
2				1	1	2			1				0:00		InHours:	4
3							1						0:30
4			1	1					2				1:00		OutofHours:	10
5				2			2						1:30
6													2:00
7													2:30		StartTime:	0:30
8													3:00		EndTime:	1:00
TRAC

Now, is it possible to have the range I input into cells AB7 and AB8 turn a color? Say yellow so it is apparent what time range you are looking at??

I know...I'm so demanding!!!

Thanks for all of your help!!

Dave M.

 

[maxflia10]

Highlight your range, go to Format/Conditional Formatting and cell value is, select a color click OK OK

 

[Davers]

Sorry, again I didn't explain myself. The times I input will change periodically, I need the highlighted range to change with whatever times I plug into it...is that possible?

Thanks,

Dave M.

 

[lenze]

What cells do you want to highlight? In your example, would Row 4 be highlighted? Also, will the time period you are lookin at always be a 30 minute interval?

 

[Davers]

Here you go....

November Forced Disconnects.xls
	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB
1	11/18/02	11/19/02	11/20/02	11/21/02	11/22/02	11/25/02	11/26/02	11/27/02	11/28/02	11/29/02
2				1	1	2			1				0:00		InHours:	4
3							1						0:30
4			1	1					2				1:00		OutofHours:	10
5				2			2						1:30
6													2:00
7													2:30		StartTime:	0:30
8													3:00		EndTime:	1:00
TRAC

And yes, it is always in half hour increments...

Does this help??

 

[lenze]

In your worksheet, select all the cells in all the rows you want to be highlighted (1e.your example M2:V8) M2 will be the active cell. Now Choose Format>Conditional Formatting. Select the formula is option. Enter this
=OR($Y2=$AB$4,$Y1=$AB$4) Format background yellow

HTH
This message was edited by lenze on 2002-11-06 15:25