LaKartoffelita
New Member
- Joined
- Apr 8, 2015
- Messages
- 13
Hi everybody,
I can't find a simple way of resolving the following problem myself:
(Using Excel 2007, PC, Windows 7)
(The solution in this thread is very close to what I am looking for, but I wasn't able to edit it to work with my data: http://www.mrexcel.com/forum/excel-...atching-id-then-compare-other-values-row.html)
I have a workbook with 4 sheets. On the first I have data, that I want to compare to the other 3 sheets and then highlight the data that's different.
These three sheets are reports from consecutive month (e.g. P1/January, P2/February, P3/March ) so if possible it would be great to have different colors, with the color for the most updated report (in this case March) overriding the other colors. (Or maybe use different formatting: grey filling for changes in P1, red font for changes in P2 and bold font for changes in P3 - I don't know how complicated that would be and I don't want it to become to complex)
I've create a google sample sheet, I hope that's ok:
(In there I added a fifth sheet to show what the result should look like)
https://docs.google.com/spreadsheets/d/145VM84ae9flqMTOb_tA9-2AiiXSI-TP_0-RU67XGdW4/edit?usp=sharing
Thanks!
I can't find a simple way of resolving the following problem myself:
(Using Excel 2007, PC, Windows 7)
(The solution in this thread is very close to what I am looking for, but I wasn't able to edit it to work with my data: http://www.mrexcel.com/forum/excel-...atching-id-then-compare-other-values-row.html)
I have a workbook with 4 sheets. On the first I have data, that I want to compare to the other 3 sheets and then highlight the data that's different.
These three sheets are reports from consecutive month (e.g. P1/January, P2/February, P3/March ) so if possible it would be great to have different colors, with the color for the most updated report (in this case March) overriding the other colors. (Or maybe use different formatting: grey filling for changes in P1, red font for changes in P2 and bold font for changes in P3 - I don't know how complicated that would be and I don't want it to become to complex)
I've create a google sample sheet, I hope that's ok:
(In there I added a fifth sheet to show what the result should look like)
https://docs.google.com/spreadsheets/d/145VM84ae9flqMTOb_tA9-2AiiXSI-TP_0-RU67XGdW4/edit?usp=sharing
Thanks!