Forum Discussion
Solved
Help needed to figure out best way to analyse information
Dear Excel Community, I would really like some help in finding a solution in analysing data in the attached Workbook. There are four columns, Columns A & B contain data from one source (Ma...
Yes, indeed.
To see the conditional formatting rule, click in a cell in column A or B, then select Conditional Formatting > Manage Rules... on the Home tab of the ribbon.
Same for columns F and G.
HansVogelaar Thanks for that, very helpful and seems to do the trick :).
Can i just check, where it's highlighted orange, that's where there is no match on either pairs of columns ?
Thanks
Raj
Yes, indeed.
To see the conditional formatting rule, click in a cell in column A or B, then select Conditional Formatting > Manage Rules... on the Home tab of the ribbon.
Same for columns F and G.
HansVogelaar Thank you 🙂