Conditional formatting not working in SharePoint
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
11,684 questions
Microsoft 365 and Office Excel For business Windows
3,888 questions
Sign in to answer