Can I highlight a selected cell in a range called Sixty,maybe color it yellow
Can I highlight a selected cell in a range called Sixty,maybe color it yellow
Last edited by zplugger; 02-06-2016 at 02:48 PM.
Try
Please Login or Register to view this content.
let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source
If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE
Walking the tightrope between genius and eejit...
Thanks Olly Is there a way so this only happens in a range called sixty?
Sure.
This code will highlight a selected cell within range "Sixty" - when a selection is made outside that range, the previous selection remains highlighted:
And this version will highlight a selected cell within range "Sixty" - when a selection is made outside that range, the previous highlight is cleared:Please Login or Register to view this content.
Please Login or Register to view this content.
Thanks Olly You just saved my day,nice work on your coding.
Ran into a problem if a cell is merged,would there be a work around for this . Say cell B2 &B3 get merged. It would still highlight the merged cells?
Make this work on Merged Cell too?
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks