Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Formula and Conditionl Formatting Help
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|