Forum Discussion
Solved
How to highlight the 5 lowest values in a column that exceed 1000
I am wanting to apply conditional formatting to a column of data to highlight the 5 lowest values that exceed 1000. I have not been able to find anything that works with over 2 hours of Google searches and trial and error. My data is in cells B18 through B67. Thanks in advance to anyone who can provide a solution.
Many thanks! This is exactly what I needed.
2 Replies
Many thanks! This is exactly what I needed.
=AND(B18>1000,B18<=SMALL(IF($B$18:$B$67>1000,$B$18:$B$67),5))With a little help from Chat gpt this formula for conditional formatting works in my sample file.
