Author Topic: How to apply 1 conditional style across several data items  (Read 679 times)

Offline cogb

  • Full Member
  • ***
  • Join Date: Jan 2014
  • Posts: 13
  • Forum Citizenship: +0/-0
Good day,

I am trying to create 1 simple conditional style that can be applied across several cells in several lists.  The style is: If the value is > 0, then the foreground color should be red.  It seems I should be able to do this, but I haven't found the solution.  Each conditional style I create seems to require a specific data item.

Thanks in advance!
Brian

Offline Lynn

  • Statesman
  • ******
  • Join Date: Apr 2008
  • Posts: 2,532
  • Forum Citizenship: +330/-1
Re: How to apply 1 conditional style across several data items
« Reply #1 on: 31 Mar 2017 08:06:48 am »
Good day,

I am trying to create 1 simple conditional style that can be applied across several cells in several lists.  The style is: If the value is > 0, then the foreground color should be red.  It seems I should be able to do this, but I haven't found the solution.  Each conditional style I create seems to require a specific data item.

Thanks in advance!
Brian

Are the lists all tied to the same query or are there separate queries for each?

You can create an advanced conditional style with an expression such as "[Value] > 0" and then apply that to one or more columns in your list. Alternatively, create the style for the list column body (using the ancestor to navigate to that level) and it will then highlight every column in your list, including columns you might drag in later.

If the expression is written as "[Query1].[Value] > 0" then you'd be limited to referencing it only on containers that use Query1. Removing the qualification should will allow it to work on other lists using different queries as long as the other queries have an item called [Value].

Offline cogb

  • Full Member
  • ***
  • Join Date: Jan 2014
  • Posts: 13
  • Forum Citizenship: +0/-0
Re: How to apply 1 conditional style across several data items
« Reply #2 on: 04 Apr 2017 07:31:14 am »
Thanks very much, Lynn.  This was very helpful.  I actually have several different lists each with its own query.  In some cases, the columns match.  So, I made a conditional style for each column that had the same name using the approach you mentioned.

Thanks again.

Offline Lynn

  • Statesman
  • ******
  • Join Date: Apr 2008
  • Posts: 2,532
  • Forum Citizenship: +330/-1
Re: How to apply 1 conditional style across several data items
« Reply #3 on: 04 Apr 2017 08:09:54 am »
Glad to know it helped!

 


       
Twittear