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.
No comments:
Post a Comment