FINDING A VALUE

[gronkette1]

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??

 

[rikrak]

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]

They need to stand out from the rest of the table - so just a color would work...

 

[rikrak]

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