Hello Excel community!
I would like to conditionally format a column containing numeric values. For example, columns containing a number between 1-3, I would like to highlight in green. However, there are numbers with decimal places in my column, and Excel does not highlight them. For example - if I apply conditional formatting, to such a column, value "2" will be highlighted, but value "2.1" will not.
I would be very thankful for any suggestions.
Best regards,
M
I would like to conditionally format a column containing numeric values. For example, columns containing a number between 1-3, I would like to highlight in green. However, there are numbers with decimal places in my column, and Excel does not highlight them. For example - if I apply conditional formatting, to such a column, value "2" will be highlighted, but value "2.1" will not.
I would be very thankful for any suggestions.
Best regards,
M
