
It would be ideal to have the ability to conditionally format a column based on Max or Min values in a column.

Or greater than, less than.

Thank you for reaching out. Currently, we offer an option to check if a number is greater or lesser than a specified value. However, setting a minimum and maximum value is not available in Conditional Formatting at the moment.
If we misunderstood your request, please provide more details or an example, and we will do our best to consider it for future implementation.

This is a request to extend the conditional formatting functionality. Format if value is max value in a column or if value is least value in a column. Less than and greater than comparisons refer to other cells in the same row or same column not to a static value.