CV Conditional Formatting based on membername in row definition A#A111:U1#XYZ:U2#ABC:U3#LMN

OS11111
New Contributor

I have a CV with a row definition A#A111:U1#XYZ:U2#ABC:U3#LMN, A#A111:U1#XYZ:U2#ABC:U3#OPQ

Please note U3 is LMN and then OPQ. 

This definition is generated by a BR.
I am trying to color a row in the CV if the U3 member is say "OPQ".

I was able to format the color based on U3(using RowE1MemberName conditional formatting) but had to make U3 the first Row Header by saying "Use Default Row Headers" false and setting U3 as Header1.
Want to see if there is some way of saying that without making the U3 as the first row header. 

Thanks,

JS 

 

 

1 REPLY 1

tomdarnall
New Contributor III

JS,

Based on your definition, won't you get two rows showing with the same A111 description?  Assuming you'd want the description on these rows to be different, how about having your BR append a :Name(x) at the end of each member filter?  If so, you could have conditional format based on HeaderDisplayText which should be unique based on what the BR passes in.

Not ideal, but it works.

Tom Darnall, CPA
CFO Solutions LLC
Solution Architect