I have a list datasheet view in MOSS 2007. I have a requirement to set the background color to green for a set of fields. There is no conditions involved. whenever users select this view, they are able to see the background color for the set of few fields.

Please let me know the pointers to get this done.

1 Answer 1


I don't think you have the option to modify the look and feel of the Cells in the datasheet view as this is essentially a cut down version of excel. You could possibly modify the standard view using CSS to get the effect you want.

Hope this helps.


  • CSS is not enough for standard list view, you should use XSLT transformation (this is default mechanism for list view rendering).
    – Alexander
    Feb 25, 2013 at 10:23
  • @Alexander XSLT is not the default for list rendering in SP 2007 (the question) or SP 2013. CSS should work just fine.
    – Christophe
    Feb 25, 2013 at 18:50
  • @Christophe, the CSS classes are the same for all list views. If you change in one place you will see the changes in other. I'm wrong? For modifying list view you should use CAML for SP2003, XSL for SP 2007 and 2010, new client rendering templates for SP2013. Could you provide links for default templates if XSL is not use for this purpose in SP2007?
    – Alexander
    Feb 25, 2013 at 19:02
  • @Alexander just open a SP 2007 list view in SharePoint Designer and you'll see there's no XSLT. Do the same with SP 2010 and you'll find the XSLT. As for CSS, of course you need to target specific views, not apply your CSS rules to the whole page.
    – Christophe
    Feb 25, 2013 at 19:14
  • @Christophe, May be you are right, I have not worked with SP2007 since SP2010 was realised. But in SP2007 you can use this method, see this post and this video.
    – Alexander
    Feb 25, 2013 at 19:52

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.