November 2010


Controlling columns in a view on a black background is not something that can done easily out of the box in SharePoint with existing themes. In order to make columns show up as white text on a black background, you can use a calculated column with a DIV as follows.

=IF(Attendance=”Not Attending”,CONCATENATE(“<DIV style=’color=white’>”,”Not Attending”,”</DIV>”),CONCATENATE(“<DIV style=’color=white’>”,Transport,”</DIV>”))

Advertisements

If you need more than seven statements, then use & as in the following example:

=IF(Itinerary=”Itinerary A”,[Stops A],IF(Itinerary=”Itinerary B”,[Stops B],IF(Itinerary=”Itinerary C”,[Stops C],IF(Itinerary=”Itinerary D”,[Stops D],IF(Itinerary=”Itinerary E”,[Stops E],IF(Itinerary=”Itinerary F”,[Stops F],IF(Itinerary=”Itinerary G”,[Stops G],IF(Itinerary=”Itinerary H”,[Stops H],””))))))))&IF(Itinerary=”Itinerary I”,[Stops I],IF(Itinerary=”Itinerary J”,[Stops J],IF(Itinerary=”Itinerary K”,[Stops K],IF(Itinerary=”Itinerary L”,[Stops L],IF(Itinerary=”Itinerary M”,[Stops M],IF(Itinerary=”Itinerary N”,[Stops N],””))))))