How to apply 1 conditional style across several data items

[cogb]

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

[Lynn]

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].

[cogb]

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.

[Lynn]

Glad to know it helped!