I'm using SharePoint 2007, with custom list.

I'm using Content Editor web part in order to design my list.

{In my list the row color determined through the item ststus. e.g: If the status equal to "NOT STARTED" the row color is red, if the row status is "COMPLETED" so the row color is green, etc..}

My question is: I succeeded to implement it only on a custom list in standard view. Is it possible to implement it on data sheet view.

2 Answers 2


Customisations to the Data Sheet View are not supported, as this is generated using the Microsoft Office Access Web Datasheet Component, which renders the grid using the same base engine as the data sheet view that Microsoft Access uses.

  • from your answer I understood that I can not design custom list in data-sheet-view. so... do you have any creative idea what can I do in order to implement some "look and feel" design on data-sheet-view? thanks! :)
    – liron
    Commented Jul 25, 2011 at 17:18
  • 2
    The simple answer is no, as the datasheet view runs as an ActiveX control, not simple HTML, so there's no way to simply use jQuery or similar to colour the markup.
    – James Love
    Commented Jul 25, 2011 at 17:27
  • Could you create a multiline dataform web part with conditional formatting to show the data as desired? The dataform web part would act "like" a datasheet and allow for editing. There might be some issues to work around with postbacking. Commented Jul 25, 2011 at 20:26
  • Hi PirateEric! I do not have the design authorize, and I think that I could implement the dataform web part only with sharepoint design. am I wrong here?
    – liron
    Commented Jul 26, 2011 at 7:12
  • 1
    @JamesLove: Apparently your answer is considered definitive enough to be copied by the MS chaps: MSDN: Apply conditional formatting for datasheet view of a SP List
    – Stu Pegg
    Commented Oct 5, 2012 at 10:07

you can use the following css in Content editor webpart to change the look and feel different for Datasheet view of sharepoint

    BACKGROUND: #d3d3d3
FORM#aspnetForm {



height: 100%; 
text-align: center; 
text-align: center; 
margin:0 auto; 
width: 980px; 
width: 100%; 

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.