Bold or Highlight columns after importing an excel spreadsheets into Lists?

Question

How can I Bold or Highlight my columns after importing an excel spreadsheets into Lists?

Answer 1

If you want to do it based on the values in the columns you could use conditional formatting.  The following article has some examples of how to implement conditional formatting.

http://sp365.co.uk/2011/09/sharepoint-designer-2010-conditional-formatting/

---

Paul Stork SharePoint Server
MVP Senior Solutions Architect: BlueChip Consulting Group
Blog: http://dontpapanic.com/blog
Twitter: Follow @pstork
Please remember to mark your question as "answered" if this solves your problem.

Answer 2

Thanks Paul,

I'm actually using Sharepoint Server 2007. Probably would've helped had I said that earlier huh? That being said, I couldn't apply the conditional formatting as described in the Article nor could I discern a workaround yet either. I'll keep trying, there's gotta be a way.

Brogan

Answer 3

You can also use Conditional Formatting in 2007, but in 2007 you have to replace the existing listview web part with a dataview web part.  The XML based listview doesn't come along until 2010.  Here's an article on how to do it in 2007.

http://office.microsoft.com/en-us/sharepoint-designer-help/apply-conditional-formatting-to-a-data-view-HA010099624.aspx

---

Paul Stork SharePoint Server
MVP Senior Solutions Architect: BlueChip Consulting Group
Blog: http://dontpapanic.com/blog
Twitter: Follow @pstork
Please remember to mark your question as "answered" if this solves your problem.

Answer 4

You can also use conditional formatting in 2007, but you have to replace the existing Listview or Listform web part with a DataView or DataForm web part first.  The XML based listview web part wasn't introduced until 2010.  Here's an article on how to do it in 2007.

http://office.microsoft.com/en-us/sharepoint-designer-help/apply-conditional-formatting-to-a-data-view-HA010099624.aspx

---

Paul Stork SharePoint Server
MVP Senior Solutions Architect: BlueChip Consulting Group
Blog: http://dontpapanic.com/blog
Twitter: Follow @pstork
Please remember to mark your question as "answered" if this solves your problem.