Microsoft 365 and Office | SharePoint | For business | Windows
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
Conditional formatting not working in SharePoint
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Anonymous
My conditional formatting isn't working since I uploaded my gantt chart to Excel.
The formulas are:
=AND(task_start<=I$5,ROUNDDOWN((task_end-task_start+1)*task_progress,0)+task_start-1>=I$5)
This should fill in cells as grey to show task progress
=AND(task_end>=I$5,task_start<I$5+1)
This should fill in cells purple to show task timeline
=AND(today>=I$5,today<I$5+1)
This rule determines which cells to foramt
Microsoft 365 and Office | SharePoint | For business | Windows
Microsoft 365 and Office | Excel | For business | Windows
Microsoft 365 and Office | Excel | For business | Windows
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
{count} votes
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(160, 17%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EYJ%3C/text%3E%3C/svg%3E)
Yanli Jiang - MSFT 31,666 Reputation points Microsoft External Staff2023-03-15T03:17:00.2566667+00:00 Hi @Anonymous ,
Could you please provide more details about this issue?
What does "My conditional formatting isn't working since I uploaded my gantt chart to Excel" mean?
Are you using these formulas in SharePoint Online list? like this:
-
Yanli Jiang - MSFT 31,666 Reputation points Microsoft External Staff
2023-03-22T08:12:45.69+00:00 Hi ,
Any update?
Sign in to comment
Sign in to answer