Category Archives: Productive

Excel row formatting rules

A great tutorial on different formatting rules:
https://www.ablebits.com/office-addins-blog/2013/10/29/excel-change-row-background-color/

Advertisements

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:

http://www.silverlightshow.net/items/Sketchflow-from-a-developer-point-of-view-Part-II-Dev-Stuff.aspx


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