Hello all you helpful people in the forum, I'm looking for assistance once again ....
I have a summary of income and expenditure in my Home sheet.
The summary consists of group totals with each Group having a hyperlink to the group range in my Accounts sheet.
Each group range is the collection of the various categories that belong to the group.
eg For "Property" (group) the link would point to (sheet) Accounts- A12:T17,
for "Health" (group) the link would point to (sheet) Accounts- A43:T46, etc
I want to have this range highlighted with a background colour (temporary fill) to clearly identify the cost components of the selected Group.
When the focus is removed from the link range, it would revert to the original state, so there is no actual action taking place other than setting the background colour..
I'm sure it can be done, but can't find anything to tell me how.
I'm hoping this can be done without VBA, but I guess I can cope if need be!!
Can someone tell me how this can be done please.
Ron S
Bookmarks