Highlight a range of cells

Davers

Well-known Member
Joined
Sep 17, 2002
Messages
1,165
Hi again!!! I've received excellent help on how to return values I need! Here is the resulting spreadsheet!
November Forced Disconnects.xls
MNOPQRSTUVWXYZAAAB
111/18/0211/19/0211/20/0211/21/0211/22/0211/25/0211/26/0211/27/0211/28/0211/29/02
211210:00InHours:4
310:30
41121:00OutofHours:10
5221:30
62:00
72:30StartTime:0:30
83:00EndTime: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.
 

Excel Facts

Why does 9 mean SUM in SUBTOTAL?
It is because Sum is the 9th alphabetically in Average, Count, CountA, Max, Min, Product, StDev.S, StDev.P, Sum, VAR.S, VAR.P.

maxflia10

Well-known Member
Joined
May 20, 2002
Messages
890
Highlight your range, go to Format/Conditional Formatting and cell value is, select a color click OK OK
 

Davers

Well-known Member
Joined
Sep 17, 2002
Messages
1,165
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

Legend
Joined
Feb 18, 2002
Messages
13,690
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

Well-known Member
Joined
Sep 17, 2002
Messages
1,165
Here you go....
November Forced Disconnects.xls
MNOPQRSTUVWXYZAAAB
111/18/0211/19/0211/20/0211/21/0211/22/0211/25/0211/26/0211/27/0211/28/0211/29/02
211210:00InHours:4
310:30
41121:00OutofHours:10
5221:30
62:00
72:30StartTime:0:30
83:00EndTime:1:00
TRAC


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

Does this help??
 

lenze

Legend
Joined
Feb 18, 2002
Messages
13,690
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
 

Forum statistics

Threads
1,143,707
Messages
5,720,386
Members
422,282
Latest member
psunith

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top