Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have Bookmark aaa, where I select Client cc.
I want to see different color for it in a chart.
Or how can I see different color just for 1 client?
I attached a simple file as an example.
Thanks,
I have some charts on 1-st sheet. I select in Multibox my selection. When I leave this sheet, I want to bookmark my selection. According my selection, show color in the chart.
Thanks,
To change a bookmark upon activating or leaving a sheet, go into the sheet's properties (right click on the sheet, then click Properties). You then need to go to the trigger tab.
Then choose Add Actions > Bookmark. It will give you these three options.
Apply Bookmark will apply selections from a bookmark that is already made.
Create Bookmark will create a totally new bookmark with the selections that are currently made.
Replace Bookmark will replace the selections of an already made bookmark with the current selections.
I hope this is helpful to you!
I did it. Each time Qv adds a new bookmark.
I've never worked with bookmarks. I want to have one bookmark, which changes current selection.
Thanks,
I've made a video on similar topic. You can Load colours from Excel file and give access to users and they change the colours (RGB values). And then we use these colours in Variables instead of hard coding them.
Hope this helps!
Cheers,
DV
Sounds like you would want to use "Replace Bookmark". This will replace a bookmark specified by "Bookmark Id" with the current selections. This will not create a new one, but will just update an already existing one.
Hi Deepak,
Your idea is good, but in not my case. Client variable is always added.
I need something universal like Bookmark (I didn't have another idea).
Hi Nicole,
I'd like to update update current Bookmark without changes its ID number.
Thanks guys,
If you use Replace Bookmark, the ID number does not change; it just changes what is in the bookmark.
Hi Nicole,
Could you update an expression
=if(Client = only({BM02} Client), rgb(139,191,31), rgb(124,124,124))
BM02 I want to change on variable Var1?
Thank you,