Is it possible to apply Conditional Formatting with a formula?
In Excel we have the ability to use custom formula for conditional formatting, is this possible in SS?
Please see screenshot below.
I need to compare column values to the value at the top cell. I can do this by adding more columns and formulas and then hide them, it would be cleaner if I can do with conditional formatting.