Hey all, I am trying to compare data in 2 different columns - when the values are not equal I want to highlight the entire row, or even just one of the data fields. Anyone have any thoughts?Thanks.
Thanks guys, I had tried something similar before posting and kept getting a 'number is required here' error - I had figured that meant I could only compare a data field against a literal number. Turns out I was getting that error because the two data fields I am trying to compare are different formats. Of course that was easily remedied and things are working like a charm now.
Either of your suggestions can be done.If you want to highlight a row, go into the section expert and click on the color tab. In there all you have to do is put in a simple formula like.if <> then crsilver else crwhiteConversely if you want to shade a field instead of the whole role you would click on the field in question and essentially type in the same formula from above in the color/background setting. You would have to type the formula for each formula if you wanted both to shade to a different color.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.