Conditional formatting not working in SharePoint

Amanda Seims 0 Reputation points
2023-03-14T14:46:25.74+00:00

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
{count} votes

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.