Wednesday, December 6, 2017

yogi_Conditionally Format Cells In B2:B If They Occur In 'CHECKOUT SHEET'!B4:B

Google Spreadsheet   Post  #2312

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     Dec-05-2017
Conditional formatting by number from sheet1 that strikes through same number in sheet2
I have a spreadsheet that we are going to use for inventory and checkout via asset numbers.
Sheet1 has the checkout log, and sheet2 has the inventory.

In sheet1, I have column B serving as the asset numbers, which is a data validated drop-down list.

The same numbers in the drop-down list in column B on Sheet1 are listed in sheet2 in column B.

I want an asset number in sheet2 to have a strike-through when sheet1 has the number added in column B.

For instance... If Sheet1 asset number 12345 is selected from the drop-down menu, then strike-through asset 12345 on Sheet2.