Good morning, I wonder whether someone can help me please.
I'm trying to put a script together which will highlight the highest and second highlight figures in a given column.
The sheets I'd like to check these for are called "Direct Activities", "Enhancements", "Indirect Activities", "Overheads" and "Projects".
For each sheet, I'd like to check each column in the range C:N independently i.e. I need to highlight the pertinent values in column C, then column D etc.
I've done quite a bit of research and found the link below.
http://www.mrexcel.com/forum/excel-q...ax-values.html
and I've put together the following code which deals with sheets and dynamic ranges (below), but I'm a little unsure about how to bring together the two.
I just wondered whether someone may be able to look at this please and offer some guidance about how I may go about acheiving this.Please Login or Register to view this content.
Many thanks and kind regards
Bookmarks