Wednesday, January 14, 2015
Our starting point – we want Grape to be highlighted because it is not the same as Cherry.
Select all of column B by clicking the header. On the Home tab, click Conditional Formatting… New Rule.
Choose “Format only cells that contain”, and “Cell Value” “not equal to” “=A1”. Note that putting the “=” is very important because otherwise Excel will think you’re comparing it to the string literal “A1”.
Then click “Format…” and select the appropriate formatting (such as setting a fill color).
Then click OK and OK.
Note: If you don’t want the header to be highlighted, you can apply the conditional formatting to only the cells with actual data, but you will have to adjust the corresponding comparison row in the formula. In our example, we might apply the conditional formatting to cells B$2$:B$5$ (which starts at row 2), but we’d have to set the formula to “not equal to” “=A2” (also starts at row 2). If you want to select down to the end of the sheet, your selection formula would be something like =$B$2:$B$1048576 on the Excel 2007+ “big grid”.
Thursday, January 8, 2015
GitHub for Windows doesn't put Git in the PATH by default. If you'd like your Node.js command prompt to have the git command available by default, simply edit your nodevars.bat file. By default, this is in C:\Program Files\nodejs\. You will have to run your text editor in an administrative context for this to work.
Replace this line in your nodevars.bat file:
With these two lines:
for /F %%A in ('"dir /s /b /OD %userprofile%\appdata\local\github\portableGit_*"') do set gitPath=%%A\bin
See this gist for an easier-to-copy version:
That will set a variable called %gitPath% with the location of git.exe, and then append it at the end of your path in the Node.js command prompt. Because of the /OD switch, it will use the version of Portable Git whose folder has the latest modified date. If Portable Git is not found, you will get a harmless extra ; in the PATH.
Tuesday, January 6, 2015
He also described how to update the lib.d.ts file later in the same issue:
These instructions are not guaranteed to work, so be sure to back up your original files.