I have the pivot table which has column A and B in the data fields, and I would like to conditional format the column B based on the value from column A - column B, is there any simple way to implement this?
According to your description of the problem, I think your issue is that conditional format the column B based on the value
from column A-column B is not possible to achieve, because the all field of your workbook will automatically be generated in the pivot table after you create a pivot table.
Based on my analysis of the issue, I can give you some other suggestions.
You can add a new field in your pivot table, and set its value based on the value from column A-column B using the CalculatedFields()