Filter or highlight the last 10 entries

  • Thread starter Thread starter Mas
  • Start date Start date
M

Mas

Hi all,

How can I filter by or hightlight the newest 10 dates in a column and then
if possible highlight the corresponding cells in the filtered rows that have
text in them.

Thanks in advance.
 
My thoughts would be to do a data > sort > descending of the entire table by
the dates col (I assume these contain all real dates). Then easily read off
the latest 10 dates (from the top down). Then for the text highlights, you
could select the data range eg: select A2:E100 (with A2 active), and apply CF
using Formula is:
=AND(ISTEXT(A2),A2<>"")
Format to taste, ok out. This will highlight specific cells within the range
which contain text other than formula returned blanks: "" (zero length null
strings)
Any good? hit the YES below
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
 
Hi all,

How can I filter by or hightlight the newest 10 dates in a column and then
if possible highlight the corresponding cells in the filtered rows that have
text in them.

Thanks in advance.
Click to expand...

Assuming your dates are in Column B starting at B1
the following conditional format will highlight the top ten dates in
the column

=B1>=LARGE(B:B,10)

regards

David
 
Back
Top