The same but different: conditional formatting in adjacent cells

I was recently looking at apartments online, trying to figure out which ones were worth stopping by in person to take a closer look at. As with any major data project I stored the information in a spreadsheet, but once I had all the data compiled there was too much to easily look at. In addition to rent I was also considering which utilities were included, how long it would take to get to to a variety of locations including work and the nearest grocery store, whether it has washer & dryer in the unit, and so on. So to easily look at all of this I wanted a visualization similar to a heatmap, but there was one problem: the data wasn’t all the same. Continue reading The same but different: conditional formatting in adjacent cells

Debugging: Finding missing closing tags

The other day I was humming along, writing HTML, but when I went to look at the result it was obvious that I’d missed a closing tag somewhere. That’s not too uncommon, and fortunately there’s a number of ways of dealing with it. My first resort if I’m working with tables or div tags is usually to make visible borders, but if that doesn’t help me pin down the problem then the next thing I try is using a spreadsheet. Continue reading Debugging: Finding missing closing tags