How would I make a macro to sort by Name, Juice and then Fruit. If the same juice is on a different fruit within the same Name then highlight the juice red. See sample.
So if Ken had:
Ken banana water or lemonade then it would be red.
or
Ken orange water or lemonade then it would be red.
but if he had:
Ken orange punch then no red
or
Ken orange grape then no red
Below is more details.
\1
Bookmarks