Conditional formating between columns based on text color Red or by B2 Bottom 20

Question

Conditional formating between columns based on text color Red or by B2 Bottom 20, plus G2 color Red or Top 20

Hi,

I need help with a conditional formatting problem.

I want to determine in my web site analytic spreadsheet if a web page is hot based on how old it is and the average of daily page views.

Column B is the number of days since the page's creation conditionally formatted as Top 20 = Blue text and Bottom 20 = Red text. All others are mid range and are black text.

Column G is the average views per day conditionally formatted as Top 20 = Red text

Thus if column B is Red or Bottom 20 and column G is Red or Top 20 = Hot page

What I want is for column K to tell me if it is a "Hot Page"

Basically MyReadingMapped has over 160 Google maps of historic and scientific events that I track and I want to determine automatically which young pages are growing fast.

Anyone ever try to do something like this?

Explanation / Answer

%#&%78872

Use a formula like this in K2.

=IF(AND(B2<=SMALL(B:B,20), G2>=LARGE(G:G,20)),"Hot Page!","")

And just this part in the CF formula option for those cells:"|

=AND(B2<=SMALL(B:B,20), G2>=LARGE(G:G,20))

or with the value is option using

"Hot Page!"

Related Questions

Navigate

• Browse (All)
• Browse C
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.