Hi
this is not possible

--
Regards
Frank Kabel
Frankfurt, Germany

"Phyliss" schrieb im Newsbeitrag
...
I have done this but I want the formatting to show on the Summary
sheet----It
doesnt carry over

"Frank Kabel" wrote:

Hi
- select A1:X1
- goto the conditional format dialog
- enter the following formual
=A1=MAX($A1:$X1)
- choose your format

--
Regards
Frank Kabel
Frankfurt, Germany

"Phyliss" schrieb im
Newsbeitrag
...
Hi
I have a 7 days of hourly temperature readings in data!A1:X7.
In B11 =max(A1:x1)
In B12 =Min(A1:X1)
In C11 =MATCH(MAX($A1:X1),$A$1:$X$1,0) Gives the hour of the Max
In C12 =MATCH(Min($A1:X1),$A$1:$X$1,0) Gives the hour of the Min

In summary!C1:I1 is the Max Temp and the time it occurred
concatenated as
Temp/Time =concatenate(data!B11,"/",data!C11)
And C2:I2 is the Min Temp and time.

On the summary I would like to conditionally format the weekly
Max
and Min.
Preferably only the temperature component but the whole cell
would
work as
well.

How do I do this
Thanks!
Phyliss