Hi,



I was curious, I have an accesss database/excel database that we manage all of our products in. I have recently been sent a sheet that has a lot of discontinued products. I have matched those skus up to the products and was wondering if there was a way to change the value in a column based on if the cell next to it has any kind of data in it.





for example



Product Name........DISCONTINUED............DIS SKU

Fabric 1......................False...................5468

Fabirc 2......................False...................

Fabric 3......................False...................9821





So I want the "False" to change to "True" in clumn "B" because there is data in COLUMN "C". I only want the Fabric 1 and 3 columns to saw true.



Is this possible?