Hi,
Can someone please help me with the following problem...
I need to compare two sets of data and if they do not match, one of the two values should be coloured in red. The problem however is, that one set of figures is contained in a row while the other one is stated in a column - I will try to explain that in detail now.
I have a table with Export Countries - e.g. Germany exports to Belgium 123, Germany to Denmark 345, Germany to Spain 678 and so on (the countries to which the export goes is in the first column; the exporting country is a header of the row) => data is in a column
Exports Germany Belgium Denmark Spain
Germany 0
Belgium 123
Denmark 345
Spain 678
The other table is Importing Countries - e.g. Belgium imports from Germany 123, Denmark from Germany 345, Spain imports from Germany 678 etc. (in this case the first column contains all the countries from where the import is coming and the headers are the importing countries) => data is in a row
Imports Germany Belgium Denmark Spain
Germany 0 123 345 678
Belgium
Denmark
Spain
Thus, the imports of one country have to match with the export from the other country.
Which formular can I apply for getting the desired result, which is, colouring the import values that do not match with the export values from the respective country.
I hope you understand what I mean...
I would be really very grateful if anyone could help me finding the solution. (If possible I would like to avoid using VBA.)
Thank you so much :)
Configuration: Windows XP Internet Explorer 7.0
Hello lizzy
|
Hi Excelguru,
|
Hello Lizzy
|
Hey :)
|
Access 2003 conditional formatting vba Conditional format blank cells if =text Conditional format if between values vba excel Conditional formatting duplicate cells in mac excel Conditional formatting excel 2007 add in Conditional formatting formula for text Conditional formatting row (duplicate from 2 columns) Copying conditional formatting to other cells Excel 2007 conditional formatting greater than today's date Excel 2007 conditional formatting two columns equal Excel 2007 hide cells conditional formatting Excel 2007 hide entire rows conditional formatting Excel conditional format insert text Excel conditional formatting if statement Excel conditional formatting more than 3 Excel conditional formatting to highlight expiry dates Ms access 2007 conditional formatting more than 3 colors Vba excel conditional format detect color