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

(Jin Tan) #1

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) #2

Do you have a relationship between these tables?

(Steven Coile) #3

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.