FINDING A VALUE

gronkette1

Board Regular
Joined
Mar 12, 2002
Messages
90
This is the table I have:
Date StnID HB0 HB1 HB2 HB3
7/1/02 FNT 76.0 75.0 72.0 68.0
7/1/02 LAN 71.0 70.0 72.0 74.0
7/1/02 GRR 78.0 77.0 79.0 78.0
7/2/02 FNT 76.0 74.0 73.0 74.0
7/2/02 LAN 75.0 78.0 76.0 73.0
7/2/02 GRR 78.0 77.0 75.0 75.0
7/3/02 FNT 73.0 73.0 73.0 72.0
7/3/02 LAN 72.0 71.0 71.0 70.0
7/3/02 GRR 75.0 74.0 72.0 72.0
7/4/02 LAN 78.0 78.0 76.0 76.0
7/4/02 GRR 79.0 77.0 76.0 76.0
7/4/02 FNT 79.0 78.0 76.0 76.0
7/5/02 GRR 66.0 63.0 62.0 61.0
7/5/02 LAN 68.0 65.0 61.0 59.0
7/5/02 FNT 68.0 65.0 63.0 62.0

Actually the complete table continues until 07/31/02 (rows) and HB23 (columns)

I need to input a date and an hour and and then have a macro that will highlight those cells...

thanks

P.S. How do I get as good as you with Excel??
 

Excel Facts

Whats the difference between CONCAT and CONCATENATE?
The newer CONCAT function can reference a range of cells. =CONCATENATE(A1,A2,A3,A4,A5) becomes =CONCAT(A1:A5)

rikrak

Active Member
Joined
Aug 21, 2002
Messages
255
Hi,

When you say:
"...and then have a macro that will highlight those cells... " ,
do you mean jump to them or just give them a color?
 

gronkette1

Board Regular
Joined
Mar 12, 2002
Messages
90
They need to stand out from the rest of the table - so just a color would work...
 

rikrak

Active Member
Joined
Aug 21, 2002
Messages
255
Hi,

I think you don't need any macro.
You can do it with 'conditinal format'

Insert a row above your data;
enter the date to search in A1;
enter the hours in C1;

select column A;
from the menbar select Format->Conditional Format->condition 1: cell value is equal to =$A$1 , select your format and hit OK;
Do the same for all the cells containing hours but set condition 1: cell value is equal to =$C$1
 

Forum statistics

Threads
1,144,441
Messages
5,724,378
Members
422,547
Latest member
Vision1291

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