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 search...
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.