11,686 questions
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(105.60000000000001, 39%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAS%3C/text%3E%3C/svg%3E)
Amanda Seims
0
Reputation points
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
3,893 questions
{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,596 Reputation points Microsoft External Staff2023-03-15T03:17:00.2566667+00:00 Hi @Amanda Seims ,
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,596 Reputation points Microsoft External Staff
2023-03-22T08:12:45.69+00:00 Hi ,
Any update?
Sign in to comment
Sign in to answer