if you are trying to compare the actual vs target columns, you probably need to create a calculated field first that finds the difference, and then base your conditional formatting based on the calculated field.
Could you please refer to this community post for additional details .
Hope this helps … it would be helpful if you could share screenshot of issue / create a sample pivot visual in Arena for us to check further.
Thanks
VInod