luglio: 2018 L M M G V S D « Ott 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31
I’d been happily using my wonderful little form for a few months now to colourify my data and thinking about how to improve it. Then a couple of weeks ago I discovered some major bugs with the whole routine when … Continua a leggere
Considering my job is in software documentation and user manuals, I’m not doing very well here. Sorry. I will try to sort this out. The VBA form has also grown. For each individual value range you can now set: bar … Continua a leggere
Mi sono sempre piaciute le barre di dati in Excel, introdotte con la versione 2007. Un particolare mi ha sempre infastidito però – non si può usare più di un colore alla volta (ovvero se nel range formattato ci sono … Continua a leggere
Negative bars One thing I noticed almost immediately with my version 1 was that negative values didn’t work correctly. If you set the default data bar range to include negative numbers you have the option to select a single colour … Continua a leggere
When I switched from Office 2003 to 2010, one of the most liberating updates was the wildly expanded conditional formatting, previously limited to just 3 conditions and some pretty basic cell formatting. Data bars caught my attention immediately as a great … Continua a leggere
This is the calendar replacement by AppSuberb that I slagged off yesterday. They published an update this morning that solved my gripe so I’ve gone from considering it a gimmick to loving it as much as WeatherCube.
General Utilities: MyTouch Calculator. What can be quicker than handwriting the sums? You can correct, insert and delete bits and the total updates. In my opinion, unbeatable. Panoramic’s Converter Pro. Yeah, the store is imploding from the number of apps … Continua a leggere