Hi, I want to compare 2 value from 2 differe...

[Jin_Tan]

Hi,

I want to compare 2 value from 2 different table. If the value is greater, then i want to format the row to be red color. How do i do that?

Example:

Let’s say Table A is a record of ordering product, Table B is a record of receiving product.

Table B needs to make sure the product has the same details as Table A. So, i will need to compare the product width.

Table A has a column name “Width” Table B has a column name “Width”

If the Width from Table B is larger than the width from Table A , then that particular row will be formatted into red colour.

[Aleksi_Alkio]

Do you have a relationship between these tables?

[Steven_Coile]

The LOOKUP() function will allow you to get a particular column value from a particular row.

For example, from a format rule for Table A, use the formula:

=[Width] < LOOKUP([_THISROW].[Product ID], “Table B”, “Product ID”, “Width”)

This assumes both tables have a Product ID column and that each product ID value occurs only once in each.