patrickteo91
Board Regular
- Joined
- Sep 12, 2012
- Messages
- 88
Hi,
I need two sets of formulas to perform checking. Payment amount in column K is definitely in local currency while Column M should be in USD. My column L would be the type of currency.
First:
I need a formula to perform checking, if Currency in column L is USD, both amount in column K and M should be the same. If not the same, I want to highlight the cell from K to M in RED.
Second:
I need a formula to perform checking, if Currency in column L is not USD, both amount in column K and M must not be the same. If they are, I want to highlight the cell from K to M in BLUE.
Thanks for your help in advance.
I need two sets of formulas to perform checking. Payment amount in column K is definitely in local currency while Column M should be in USD. My column L would be the type of currency.
First:
I need a formula to perform checking, if Currency in column L is USD, both amount in column K and M should be the same. If not the same, I want to highlight the cell from K to M in RED.
Second:
I need a formula to perform checking, if Currency in column L is not USD, both amount in column K and M must not be the same. If they are, I want to highlight the cell from K to M in BLUE.
Thanks for your help in advance.