Highlight a max number
hey gang,
easy one here (I'm assuming).
ColAO contains 18 numbers, from AO3-AO20. The numbers change constantly
while I input data. How can I make the current high number change color? I
know it with conditional formatting, but can't seem to get the formula
correct. Also - if 2 or more numbers are currently the highest, both should
be highlighted.
Thanks,
Matt
|