Sign in
 
HomeOnline20132010Other VersionsRelated ProductsLibraryForumsGallery
TechCenter >
> 
> 
Apply conditional formatting for datasheet view of a SP List

Answered Apply conditional formatting for datasheet view of a SP List

  • Thursday, May 24, 2012 4:47 PM
     
     
    Sign In to Vote
    0

    Hi,

    Is it possible to apply colored conditional formatting for the columns in a datasheet view of SP list?

     

All Replies

  • Friday, May 25, 2012 5:17 AM
     
     
    Sign In to Vote
    0
    No, the ActiveX control cannot be manipulated.
     
  • Friday, May 25, 2012 6:18 AM
     
     
    Sign In to Vote
    0

    Hi

    yes you can do it using SHP Designer,

    Let me know the real request and i will try to show you How to do it

    Romeo Donca, Orange Romania (MCSE, MCTS, CCNA) Please Mark As Answer if my post solves your problem or Vote As Helpful if the post has been helpful for you.

     
  • Friday, May 25, 2012 3:49 PM
     
     
    Sign In to Vote
    0

    Hi Romeo,

    I have a SP list with several columns. Among all, there are two numerical columns that have values in percentage %.

    I want to have the columns (cells) to be colored when the % reach to a certain range:

    • If the value is less than or equal to 75%, then color the cell background with Red
    • If the value is greater than 75% and less than 85%, then color the cell background with Yellow
    • If the value is greater than or equal to 85%, then color the cell background with Blue .

    Thanks!

     
  • Friday, May 25, 2012 3:57 PM
     
     
    Sign In to Vote
    1

    Hi

    i postes a cuasi similar post on my site, but the condition was to compare 2 columns

     

    The post's name is

    Conditional Formatting issue, posted on 2012 April

    Check it , and if you need more help, let me know i will prepare an example for you, for your needs

    Romeo Donca, Orange Romania (MCSE, MCTS, CCNA) Please Mark As Answer if my post solves your problem or Vote As Helpful if the post has been helpful for you.


    • Edited by romeo donca Friday, May 25, 2012 3:58 PM
    •  
     
  • Saturday, May 26, 2012 7:16 AM
     
     
    Sign In to Vote
    0

    Thanks Romeo.

    But the post that you wrote was for the data view web part of a list... i want to have the conditional formatting applies in the datasheet view, but not a standard view of the list..  

     
  • Tuesday, May 29, 2012 2:04 AM
    Moderator
     
     Answered
    Sign In to Vote
    0

    Hi ,

    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. As the datasheet view runs as an ActiveX control, not simple HTML, so there's no way to simply use JQuery or similar to color the markup .

    You can change the background color of the datasheet view .For more information ,you can refer to this site:

    Background color of a DataSheet view: http://www.sharepointboris.net/2009/02/background-color-of-a-datasheet-view/

    Thanks

    Entan Ming

    TechNet Community Support

     
  • Friday, October 05, 2012 10:05 AM
     
     
    Sign In to Vote
    0

    The source of this answer can be found here:

    SPSE: Customising Data Sheet View


    • Edited by Stuart Pegg Friday, October 05, 2012 10:05 AM Fixed link
    •