Hello
I need to compare different projects and information on the projects -
I need to compare, profit, cost and turnover
For each project (I have about 50 projects) I have 3 levels of details - So I will have 3x3 cells in Excel on each project.
For each column ie. Profit I have to compare the values of the 3 cells and see if they match or not.
So my question is then, is there a easy function to get excel to mark the 3 cells for the three different informations (profit, turnover and cost) and compare them and if they are not identicial get it to change cell colour ?
I perhaps have a hard time explaining my situation well, sorry for that, however I hope someone can guide me in the right direction - Thanks in advance!
I need to compare different projects and information on the projects -
I need to compare, profit, cost and turnover
For each project (I have about 50 projects) I have 3 levels of details - So I will have 3x3 cells in Excel on each project.
For each column ie. Profit I have to compare the values of the 3 cells and see if they match or not.
So my question is then, is there a easy function to get excel to mark the 3 cells for the three different informations (profit, turnover and cost) and compare them and if they are not identicial get it to change cell colour ?
I perhaps have a hard time explaining my situation well, sorry for that, however I hope someone can guide me in the right direction - Thanks in advance!