Hi All,
I would like to create a report using conditional formatting. I want a field to be formatted based on two conditions. one based on column and the other based on row. As highlighted in the image(red circles), only the intersecting fields should be formatted according to the given condition. I am using normal table (not the pivot) to do this.
FYI,
column level conditional formatting:
Row level conditional formatting:
I also noticed that the output is strange. Although I applied same formatting for the four columns the output is not same.
I want the report to be formatted as shown in the below image. In the column level gap I have inserted the Variance % column. Kindly share your ideas to achieve this.
Thanks in advance
