Category Archives: Productive

Excel row formatting rules

A great tutorial on different 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:


Interesting read:

Column Matching in Excel

Use this script to find all the matching rows between col A and C. To use:

  1. Set col C range in macro.
  2. Select all col A in worksheet.
  3. 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