I need help for my one of the dynamic report where one part of conditional formatting is done using excel functionality. But another part I am not able to achieve. Below is the issue in detail.
1. As per screen shot if Red color highlighted cell system found then immediate adjacent cell (prior to formatted cell) should also fill with Red color.
2. Example : Cell E2 is not color currently but F2 is colored.
3. In other way if total of 12345 account is not match with 4444 account then 12345 account total should be fill with color.
Is there any way out using macro if this is possible. Or if any excel formula can fulfill this requirement please help on the same.