Conditional Formatting on Payments with same or differenct currency

[patrickteo91]

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.

 

[miss_ell]

Hello,

Highlight the cells you want formatted, then go to Format, Conditional Formatting.

For the first condition, choose Formula Is, then paste =AND($L2="USD",$K2<>$M2), colour red.

Add a second condtion, paste =AND($L2<>"USD",$K2=$M2) in the formula box, colour blue.

I hope this helps.

 

[patrickteo91]

Many thanks miss_ell.
Its working fine.
Have a nice day & weekend ahead.

Hello,

Highlight the cells you want formatted, then go to Format, Conditional Formatting.

For the first condition, choose Formula Is, then paste =AND($L2="USD",$K2<>$M2), colour red.

Add a second condtion, paste =AND($L2<>"USD",$K2=$M2) in the formula box, colour blue.

I hope this helps.

 

[miss_ell]

Hi Patrick,

I'm glad it works out for you. Thanks for the feedback!