I am currently working on a spread sheet for my work place where I need to check whether the database's information is accurate compared to the hard copies. I wanted to make it easy to check through the 700 rows of information.
I have managed to get an excel document of the database information, with the different fields in their own columns. However, the database's information is exclusive of tax, which is 10% here.
As such, what I would like to do it lock the cells of the database information and place columns next to each database column field, so that I can input the hardcopy data and have a third column next to it which goes red if the database column data doesn't match the hard copy column data less 10%.
I have been using the formula (Hardcopy/11*10) to get the excluded tax amount, but I don't know how to get the column to turn red when the numbers don't match, and turn green when they do match.
I am placing an example here to help explain what I need
<tbody>
</tbody>
If at all possible, I would also like to make it only tolerant to 2 decimal places as all the figures are either cash related or percentages only detailed to 2 decimal places. (eg. $1.20 or 8.88%)
Thank you very much in advance. Any information you provide will save me hours of pain in the near future.
VERY IMPORTANT
I am using Microsoft Excel 2010, however since the list needs to be shared with a work mate as we are sharing the load on doing this list, the formulas need to work for Microsoft Excel 1997.
I have managed to get an excel document of the database information, with the different fields in their own columns. However, the database's information is exclusive of tax, which is 10% here.
As such, what I would like to do it lock the cells of the database information and place columns next to each database column field, so that I can input the hardcopy data and have a third column next to it which goes red if the database column data doesn't match the hard copy column data less 10%.
I have been using the formula (Hardcopy/11*10) to get the excluded tax amount, but I don't know how to get the column to turn red when the numbers don't match, and turn green when they do match.
I am placing an example here to help explain what I need
A | B | C | ... | |
Database | Hardcopy | Match/No Match | ||
1 | 5.50 | 5.0 | X | |
2 | 6.60 | 6.1 | X | |
... |
<tbody>
</tbody>
If at all possible, I would also like to make it only tolerant to 2 decimal places as all the figures are either cash related or percentages only detailed to 2 decimal places. (eg. $1.20 or 8.88%)
Thank you very much in advance. Any information you provide will save me hours of pain in the near future.
VERY IMPORTANT
I am using Microsoft Excel 2010, however since the list needs to be shared with a work mate as we are sharing the load on doing this list, the formulas need to work for Microsoft Excel 1997.
Last edited: