SharePoint List Colors – Office 365 SharePoint 2013/2016

Color Status Indicator

Verified 2016

 http://christine-payton.com/color-coding-a-sharepoint-list/

Grade Example

Create Numerical Column named Score

Create Calculated Column named Grade

=IF([Score]>89,"A",IF([Score]>79,"B", IF([Score]>69,"C",IF([Score]>59,"D","F"))))

Create Calculated Column named Color … hidden in final view

=IF([Score]>89,"Green",IF([Score]>79,"Green", IF([Score]>69,"Yellow",IF([Score]>59,"Red","Red"))))

Create Calculated Column named Status … note must be numeric

=CONCATENATE("<div style=",CHAR(34),"height:20px;width:20px;border-radius:3px;background-color:",[Color],CHAR(34),">&nbsp;</div>")

UPDATE: border-radius:100% changes it to circle

More

My 'Title' field returns the following results:

ie: Gold.png

I want to remove '.png' and just leave the word 'Gold'

=REPLACE([Title],SEARCH(".png",[Title]),"4","")

References

https://blog.splibrarian.com/2012/06/06/using-calculated-columns-to-add-color-coding-to-your-sharepoint-lists/

https://support.office.com/en-us/article/IF-function-7025be14-5665-43d0-af20-8293d1fe9d3a

https://www.w3schools.com/tags/ref_colornames.asp

Calender

https://www.premierpointsolutions.com/training/help-and-how-to-articles/color-code-events-on-a-sharepoint-calendar/

https://www.degdigital.com/insights/four-easy-steps-to-customized-color-code-calendars-in-sharepoint/

http://eimagine.com/sharepoint-color-coding-your-calendar-by-category-tutorial/

Calendar - Office 365

https://stoneridgesoftware.com/creating-a-color-coded-calendar-in-sharepoint-online/

SharePoint Branding

2019

Branding guidance for SharePoint

Branding guidance for SharePoint Online portals
https://docs.microsoft.com/en-us/sharepoint/dev/solution-guidance/portal-branding

How to brand SharePoint and Office 365 Out of the Box
https://sharepointmaven.com/how-to-brand-sharepoint-and-office-365-out-of-the-box/

Branding for SharePoint sites in Office 365https://www.abelsolutions.com/branding-sharepoint-sites-office-365/

SharePoint Site Theming
https://docs.microsoft.com/en-us/sharepoint/dev/declarative-customization/site-theming/sharepoint-site-theming-overview

Theme Generator
https://developer.microsoft.com/en-us/fabric#/styles/themegenerator

Branding SharePoint: The New Normal (M365)
https://blogs.msdn.microsoft.com/bobgerman/2018/09/04/branding-sharepoint-the-new-normal/
https://bob1german.com/2018/09/04/branding-sharepoint-the-new-normal/

Office 365

Branding SharePoint: The New Normal

https://bob1german.com/2018/09/04/branding-sharepoint-the-new-normal/
Repost
https://techcommunity.microsoft.com/t5/Microsoft-SharePoint-Blog/Branding-SharePoint-The-New-Normal/ba-p/241855

2013 / 2016

Composed Looks

Deploy a custom theme in SharePoint
https://docs.microsoft.com/en-us/sharepoint/dev/general-development/how-to-deploy-a-custom-theme-in-sharepoint

SharePoint 2013: Creating a Composed Look
https://social.technet.microsoft.com/wiki/contents/articles/30903.sharepoint-2013-creating-a-composed-look.aspx

Use composed looks to brand SharePoint sites
https://docs.microsoft.com/en-us/sharepoint/dev/solution-guidance/use-composed-looks-to-brand-sharepoint-sites

Step by Step: Create a SharePoint 2013 Composed Look
https://bniaulin.wordpress.com/2012/12/16/step-by-step-create-a-sharepoint-2013-composed-look/

Create a SharePoint 2013 Theme using Color Palette Tool
https://en.share-gate.com/blog/create-sharepoint2013-theme-using-color-palette-tool

Branding Links Recommended by Students (Thx Jon)

http://sharepoint.stackexchange.com/questions/84412/modifying-top-navigation-through-css

https://kogzee.wordpress.com/2013/08/07/style-sharepoint-2013-top-navigation-global-navigation-menu/

http://www.sharepointdiary.com/2014/11/sharepoint-2013-top-navigation-bar-branding-css.html

http://www.macaalay.com/2014/01/28/how-to-remove-sharepoint-2013-quick-launch-andor-top-link-bar/

https://discoveringsharepoint.wordpress.com/2013/03/19/programmatically-set-navigation-settings-in-sharepoint-2013/

https://chrisstahl.wordpress.com/2014/03/31/customizing-sharepoint-2013-global-navigation-with-css-and-jquery-part-5/

https://social.msdn.microsoft.com/Forums/en-US/eed6e044-3c14-43cd-9885-2490a0121e79/move-top-navigation-bar-in-sharepoint-2013?forum=sharepointcustomization

http://stackoverflow.com/questions/25036569/sharepoint-2013-css-move-around-global-navigation-elements

https://wordpress.org/support/topic/move-top-nav-bar-down

http://en.share-gate.com/blog/create-sharepoint2013-theme-using-color-palette-tool

https://msdn.microsoft.com/en-us/library/office/jj927175.aspx

Themes

Team Sites to inherit master page and theme
http://www.sharepointeurope.com/blog/2013/7/22/sharepoint-branding-team-sites,-inherit-theme-and-master-page-on-office-365

Change the default theme of a site collection and future subsites.
http://sharepoint.stackexchange.com/questions/79750/is-there-a-way-to-change-the-default-theme-of-a-site-collection-and-fututre-subs

Composed Looks - Use composed looks to brand SharePoint sites
https://msdn.microsoft.com/en-us/library/office/dn985875.aspx
http://sharepoint-community.net/profiles/blogs/creating-and-applying-a-composed-look-in-sharepoint-2013
https://bniaulin.wordpress.com/2012/12/16/step-by-step-create-a-sharepoint-2013-composed-look/

All you need to know about site logo size in SharePoint 2013
http://blog.incworx.com/blog/sharepoint-administrators-blog/all-you-need-to-know-about-site-logo-size-in-sharepoint-2013

Branding

SharePoint Branding - Themes, Master Pages, and Page Layouts
Excerpt below from above …

Theme:
     - we want our logo
     - we want our colors
     - we want our fonts
     - we want background image
Master Page:
     - we want site logo to link to start page, not to subsites
     - we want another navigation
     - we want links on the top
     - we want footer on every page
     - we want a big banner on the top
     - we want breadcrumb
Page Layouts:
     - we want more content zones on the page
     - we want a content zone on the right for related links and content
Styling
    - we want 20px or 30px margins
    - we want larger headings (H1,H2,H3..)
    - we want border around content

Guide to quick SharePoint 2013 branding
http://blog.blksthl.com/2013/02/26/a-guide-to-quick-sharepoint-2013-branding/

Step by Step
http://www.sharepointempower.com/Blog/Post/3/SharePoint-2013-branding-step-by-step

Start Master Pages
http://startermasterpages.codeplex.com/

How do I apply master page changes to all subsites in SharePoint 2013?
http://sharepoint.stackexchange.com/questions/61979/how-do-i-apply-master-page-changes-to-all-subsites-in-sharepoint-2013

Hide Recent
http://sharepoint.stackexchange.com/questions/61347/how-to-hide-recent-in-the-navigation

Tips on Team Site
Recent Heading – current navigation (five most recent appear)
http://blogs.office.com/b/sharepoint/archive/2012/07/25/the-new-team-site.aspx

SharePoint 2013 Design Manager
http://sharepointfordeveloper.blogspot.com/2013/06/sharepoint-2013-design-manager.html
MSDN - Overview of Design Manager in SharePoint 2013
https://msdn.microsoft.com/en-us/library/office/jj822363.aspx

2010

Basics
https://www.nothingbutsharepoint.com/sites/eusp/Pages/Hack-SharePoint-Master-Pages-Introduction.aspx

Navigation
https://www.nothingbutsharepoint.com/sites/eusp/Pages/Brand-SharePoint-Global-Navigation-The-Journey-Begins.aspx

Mega Menu

http://www.nothingbutbranding.com/blog/2012/august/mega-menu-dropdown-sharepoint

Move Quick Launch – to the Right Side

http://www.nothingbutbranding.com/blog/2012/august/move-sharepoint-quicklaunch-to-the-right

Heather Solomon - great presentations on branding in 2007 and is now working on 2010
http://www.heathersolomon.com/blog/

SharePoint Deletion Log

SharePoint has a powerful report for file deletion in SharePoint 2016 / 2013.

Under Site Collection Administration > Site Collection Audit Settings
Turn on all events needed for audit, but remember this will significatly increase the size of your content database.

So consider turning on Audit Log Trimming which is end of the month by default
https://support.office.com/en-US/article/Configure-audit-settings-for-a-site-collection-F5A346D0-EE0F-4412-A5E6-D9B5ABAA1012



Next, lets create some activity using built-in document library.

Add and delete document.

Back to Site Collection Administration > Audit Log Reports > Deletion
 Save report (Suggestion: Create a new document library for audting)

Open Report using Excel or Excel Web App

Auditing in SharePoint

Articles

SharePoint 2016

Excel Import Permissions
http://www.sharepointdiary.com/2015/05/export-sharepoint-users-and-group-permissions-to-excel.html
Audit Specific Event ID Function
https://howtodowithsharepoint.wordpress.com/2016/11/26/sharepoint-20162013-event-log-monitoring-by-automation/

Configure audit settings for a site collection (2016)
https://support.office.com/en-us/article/Configure-audit-settings-for-a-site-collection-A9920C97-38C0-44F2-8BCB-4CF1E2AE22D2
More from The Cloud EngineerSharepoint Deletion Log
http://thecloudengineer.blogspot.com/2016/03/sharepoint-deletion-log.html

Office 365

Office 365 Audit Logging
https://www.petri.com/office-365-audit-logging-generates-data

SharePoint Legacy

SharePoint 2013

Enables auditing of how site collections, sites, lists, folders, and list items are accessed, changed, and used
https://msdn.microsoft.com/en-us/library/ms441917.aspx

SharePoint Server 2013 custom audit log report - PowerShell script
https://gallery.technet.microsoft.com/office/SharePoint-Server-2013-9657c24e
Using PowerShell Scripts to Implement SharePoint Audit Logging (part 1 and part 2)
http://www.coyotecrk.com/using-powershell-scripts-implement-sharepoint-audit-logging-part-1/
http://www.coyotecrk.com/using-powershell-scripts-implement-sharepoint-audit-logging-part-2/
View and configure usage analytics reports in SharePoint Server 2013
https://blogs.technet.microsoft.com/tothesharepoint/2014/01/23/view-and-configure-usage-analytics-reports-in-sharepoint-server-2013/
Auditing - A Built-in Feature of SharePoint 2010
https://www.codeproject.com/articles/431342/auditing-a-built-in-feature-of-sharepoint

More Tools

SharePoint Audit Logging

https://support.office.com/en-us/article/Configure-audit-settings-for-a-site-collection-A9920C97-38C0-44F2-8BCB-4CF1E2AE22D2

https://www.ultimatewindowssecurity.com/sharepoint/default.aspx

SharePoint Deletion Log Report

http://thecloudengineer.blogspot.com/2016/03/sharepoint-deletion-log.html

SharePoint Permissions Analyzer

TechNet - SharePoint PowerShell: Get list of all users present in a site under different SharePoint Groups
http://social.technet.microsoft.com/wiki/contents/articles/31301.sharepoint-powershell-get-list-of-all-users-present-in-a-site-under-different-sharepoint-groups.aspx
https://sppermissionanalyzer.codeplex.com/

Simple SharePoint Permissions Auditing – OOTB

The question is how do I view permissions and perform a site auditing using out of the box tools.  Using PowerShell script found from fellow Buckeye SPUG member Brian Jackett, I was able to create an excel report below.
https://briantjackett.com/2013/07/01/powershell-script-to-enumerate-sharepoint-2010-or-2013-permissions-and-active-directory-group-membership/
First I needed to add the policy at the web application level.
Second I ran the script and dumped out an xml file.
Finally results displayed by using Excel import from the XML file for a small lab setup.

Displaying XML in SharePoint

http://thecloudengineer.blogspot.com/2015/11/displaying-xml-in-sharepoint.html

Auditing - A Built-in Feature of SharePoint

http://www.codeproject.com/Articles/431342/Auditing-A-Built-in-Feature-of-SharePoint

SharePoint Foundation

http://auditlogsp.codeplex.com/
2010

• SharePoint 2010 Audit Configuration
• SharePoint 2010 View Audit Log Reports

Project Honolulu – Management Tool

Microsoft Project Honolulu

Install was smooth on Windows 10, but …

Run as different user since Edge is needed and won’t run as domain admin

Run winrm quickconfig

Alternate Creds needed

Up and running in a few minutes and looks nice.

Yeah !!! powershell remote

Download
https://aka.ms/HonoluluDownload

Reference
https://docs.microsoft.com/en-us/windows-server/manage/honolulu/honolulu

Note WMF 5.1 prerequisite download WMF 5.1.

More Info