Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I need to change the background color of field in a straight table based on a value that is not being included in the straight table. For example, I want to change the background color of the user name who ever worked in Pennsylvania. However the state names are NOT being displayed in the table. Only the user name and a series of measures.
Name | # of Calls | # of Days Worked | # of Complaints |
---|---|---|---|
Steve | 50 | 3 | 2 |
Frank | 60 | 4 | 10 |
Tom | 40 | 4 | 0 |
Beth | 75 | 3 | 15 |
Tom worked in Pennsylvania.
Thanks in advance for your help!
Hi Frank,
should work with a construction to concatenate all states and check any match.
as aircode:
IF(WILDMATCH(CONCATENATE(State, '|'), 'Texas'), LIGHTRED())
Peter
Why not?
See the attached file
HTH Peter
try with
if(count({$ <state={Pennsylvania}>} state)>0,red())
In addition to Peter and Massimo...
Grtz. Fred
Peter
This works fine if a person only has 1 state. But my data has multiple states for each person. How can I find PA in the list of all the states that a name has?
thanks
Hi Frank,
should work with a construction to concatenate all states and check any match.
as aircode:
IF(WILDMATCH(CONCATENATE(State, '|'), 'Texas'), LIGHTRED())
Peter
Peter
thanks. I was able to get it to work!