Sometimes, use slicers instead of conditional formatting: It is easier and displays particular information. To use this tool, change data into table. For example, if you want to find out a house with 4 bedrooms, 3 bathrooms, and has the least price among all, check out with slicers. To fo find the least price, sort the "Listing price" as ascending order.