I’m currently working on implementing score comparisons in my setup. The idea is to highlight cells in green if the current score matches the maximum score, and in red if it doesn’t. To achieve this, I added an extra row with a formula that compares the values. Currently, it displays the current score only when it matches the max score; otherwise, it remains blank.
I then set up a coloring rule where cells turn green if they are not empty and red if they are. However, I would prefer the number to be visible even when it doesn’t match. The challenge is that altering the formula to display the number in such cases disrupts the coloring rules due to their limitations.
Is there a way to use formulas to apply cell colors based on specific conditions, even when the content is displayed?
Thanks in advance for your assistance!