Color the first row when the document is opened

[Anonymous]

Hi

I have a table in which I need to color the value based on sort order , so what ever value is sorted first - Row should be colored , but this action should take place only when user opens the document ,I mean when user selects some other value which is the secong row as per the sort order , it should color second row. How do I achieve this.

Thanks

[#2]

Can you mock-up what you want with Excel and send some screenshots please?

[#3]

Afraid I can't help you there - I don't download and open others' applications.

Screenshots and a better description - and I may be able to assist.

Just guessing though...

I'm assuming you've got a list of APIs and some details about the APIs in a list below that?

[Anonymous]

Here is the screen shot of the Table : I want the first row in the Table to be highlighted when the App is opened.

So the highlighting is basically selecting the API "display work progress" , but I cannot hard code this value in the Open document triggers, because there might be some other value after few days , so the highlighting should be on sort order , first value in the table.

And here is the screenshot of charts below that,

[#5]

That's easier, thank you. 

By colouring in, I think that you mean selected?

I'd suggest a trigger on activation of the the sheet.  Right-click on the sheet that you're working on and select Properties.  Then select the Triggers tab, then the Add button.

From the Action Type list use 'Selection' and from the Action list use 'Select in Field'.  (These are the defaults.)  Press OK.

You'll now have a couple of things to fill in; Field and Search String.

Assuming that the column is called 'ServiceAPI', set the fields to the following values:

• Set Field to...
  • ServiceAPI
• Set Search String to...
  • =min ( {1} ServiceAPI )

When the user first opens the document this will select the lowest value for the API - same as if they'd clicked on that first API in the list by hand.  And as it's now selected, I'd hope that your chart below would also update appropriately.

*** EDIT ***

You don't necessarily want the min ( API ) I've realised.  You want the first one in the table selected.  Back later - work to do!

[mato32188]

Hi,

set 2 variables in variable expression tab;   vColor     =Pick($(vSwitch), YourColor, White()) 

                                                              vSwitch   without value

in your chart dimension for each field to be highlighted edit background color:  =if(RowNo()=1,$(vColor))

in document properties, triggers tab:       Document Event Trigger, OnOpen   create External-SetVariable vSwitch with                                                             value 1

optional:

in your sheet:                                        create action button to restore white color External-SetVariable vSwitch with

                                                            value 2

BR

M

[Anonymous]

Please find the attached App , I get an error :

And also will this change the color of entire row ? or just the dimension , I am trying to get the color for entire row which is sorted - first row when the document is opened. But later is a value is selected from the table that row has to be colored, so basically which ever row I click that row has to be colored. !

[mato32188]

Hi,

I am not able to open your doc since I have only PE.

Coloring need to be set for each column (background color). It would color only first row RowNo(Total)=1 by your second parameter in IF statement...

BR

M

[Anonymous]

I am unable to implement this 😞