Find and auto colour based on 2 conditions

[renosa]

Hi all,

I have 2 columns A(currencies), B(amounts).

I want to auto-color the amount if the certain currency and amount match with the currency and amount in another table.

Thank you

 

[Col Delane]

Hi Renosa & welcome to the Forum

The solution will depend on how you data is laid out (in both tables), but I would suggest applying Conditional Formatting to column B to colour the amount cells, using a custom formula that returns a TRUE result when the "certain currency and amount match with the currency and amount in another table" test is satisfied. Creating the CF custom formula is the tricky bit & depends on your layout, which you may need to re-arrange, or add to, in order to provide the ability to match your currency-amount combinations.

HTH