The formatting feeds from this grid, which you can see on the second worksheet. Regular cell borders do though, so the answer was to put double line borders around all the digit cells and then have the conditional formatting “erase” the unneeded ones. Conditional formatting doesn’t have this option. The first issue was how to have doubled lines for cell borders. Each digit would consist of two cells on top of each other. My basic idea was to use conditional formatting cell borders to form the digits. To see the full works click on the second worksheet tab. You can adjust the time to your location, instead of that of your server, with the “Hour Offset” setting. (See the download at the end for full automation). Not very convenient, but the best I can do without macros. Let me know if I’m wrong, but meanwhile here’s a conditional formatting digital clock in a live workbook.Īs the notes in the worksheet above say, you can update this clock by clicking in a cell and hitting F9. But as far as I can tell there aren’t any created using conditional formatting. As I imagined, there are quite a few out there: Juan Pablo Gonzalez already had one on DDOE back in 2004, Andy Pope’s is indistinguishable from the real thing, and Tushar Mehta’s is accurate to within one nanosecond every three years. I was staring at a video player the other day and thinking about digital clocks, specifically, of course, digital clocks created in Excel.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |