If you are a regular follower of this site, you know that I have a high regard for Christophe's No Deployment Solutions at Path to SharePoint
. I use his solutions in the live online workshops, especially when it comes to color coding lists and calendars.
One of the problems with "rolling your own" when it comes to these solutions is that most people are novices when it comes to creating forumulas. Dessie Lunsford has provided a tremendous resource when it comes to Taming the Elusive Calculated Column
, but when you need a quick one-off to setup a color coded list, it's tough to spend an hour hunting and pecking for the right formula.
Help is here with Christophe's online calculated column formula generator
. Choose the colors you want to display for each value in a Status column, press the button and "Voila!", you' ve got a forumla.
This is going to be a great addition to your tool kit when creating HTML forumulas in your calculated columns. Take a look and let me know what you think. I'm already using it and I only found it 15 minutes ago!
Screenshot of the Calculated Column Formula Generator