Hi all,
Another question one day hopefully i will be able to contribute. I know it is possible to highlight the highest and lowest value in a given range, however what if i wanted to highlight the highest and lowest every nth row. I need to highlight the highest and lowest value every five rows i.e if i have a range of A1:A100 i woud like to highlight the highest and lowest value in A1:A5, A6:A10 and so on. is this possible? Thanks in advance for your help.
Regards
Dan
Bookmarks