A great tutorial on different formatting rules:
https://www.ablebits.com/office-addins-blog/2013/10/29/excel-change-row-background-color/
Category Archives: Productive
Excel row formatting rules
Sketchflow – ChangePropertyAction
One thing I wanted to do was show/hide some elements. This is actually quite easy:
Assets -> Behaviours -> ChangePropertyAction
Then you set the visibility property on which ever trigger you like.
This blog lead me to it:
http://www.silverlightbuzz.com/2009/07/14/using-sketchflow-and-behaviors-for-quick-easy-demos/
Interesting read:
Column Matching in Excel
Use this script to find all the matching rows between col A and C. To use:
- Set col C range in macro.
- Select all col A in worksheet.
- Run maco and wait.
All matches are listed in col B.
To make the macro, hit Alt+F11, create new Module, then paste this code:
Sub Find_Matches() Dim CompareRange As Variant, x As Variant, y As Variant ' Set CompareRange equal to the range to which you will ' compare the selection. Set CompareRange = Range("D2:C10021") ' NOTE: If the compare range is located on another workbook ' or worksheet, use the following syntax. ' Set CompareRange = Workbooks("Book2"). _ ' Worksheets("Sheet2").Range("C1:C5") ' ' Loop through each cell in the selection and compare it to ' each cell in CompareRange. For Each x In Selection For Each y In CompareRange If x = y Then x.Offset(0, 1) = x Next y Next x End Sub