Finding Streaks with values of 70°F or higher

[Cambium]

I am basically trying to find the longest streak where dewpoints have been 70°F and above.

I am slowly entering the daily numbers into my file with each year on seperate tabs.

But instead of manually looking for these "streaks", is there a way to tell Excel to find them and highlight them? this way I can scroll through and where the longest streak was for that year.

Going further... If 70+ is highlighted in green is it possible to get the streaks of 60+ highlighted in yellow?


I only manually did it for a short time period back to 2003. I want to use all year back to when records started for this location in 1948.

As you can see the streak of 70+ dewpoints we're experiencing is insane.
temps26.jpg

I attached the excel file.

[Fotis1991]

Do you mean something like this? I made an example for 2010!

[Cambium]

Do you mean something like this? I made an example for 2010!

Holy smokes you are the best. You guys keep showing me there's no limit with Excel.

Thats awesome! Only thing is I would like the 70 in green not yellow. So 70 and above green, 60 and above yellow.

Let me know what formula was used. You got me very excited.

[Fotis1991]

Thank you for your good words,

Slight modification done!

In Conditional Formatting rules, formula for green is:

=$B2>=70

For yellow is:

=AND($B2>=60,$B2<70)

How can you use Conditional Formating.

--In Excel 2007 and 2010, Conditional Formatting is in the Styles group on the Home tab. In Excel 2003, Conditional Formatting is on the Format menu. See here how you can work using CF.

[zbor]

I obviously missunderstood word "streak"...

But this is what I came with (year 2002) with two helper columns (you can hide them if you want)...
of course, if Fotis solution works then go with it since this is giving you othar kind of result but since I've already made it, here it is.
I've also removed several sheets due to file size.

[Cambium]

I Didnt realize the conditional formatting tool at the top. What seemed easier for me is to click on "highlight cell rules" then click "between".

I tried to do a new rule and enter the formula but I'm not getting it to work for some reason.

So if my thoughts are correct I have to highlight the column I'm looking for, go to highlight cell rules and do this on each tab.

Or is there a quicker copy and past a formula for each tab?

I'll click on the CF help later on. You guys helped me a lot. Thanks!!

[Fotis1991]

Thank you for the rep..

As looks that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thank you.


Edit: I don't know if Zbor has any other idea, but i think that you just need to copy paste the formulas in eatch tab..