Changing conditional formatting to fit quarters / months rather than days

[CWebbers]

Hello,

the file attached has conditional formatting based on the current set up of days but really want to change to Months & Quarters in the same type of format.

However every time I even attempt I fail miserably, would anyone please be able to help?

Formula for grey - =AND(task_start<=I$5,ROUNDDOWN((task_end-task_start+1)*task_progress,0)+task_start-1>=I$5)
Formula for purple - =AND(task_end>=I$5,task_start<J$5)
Formula for Red outline - =AND(TODAY()>=I$5,TODAY()<J$5)

I want the date to be Q1 24 etc and columns below reduced to Jan/Feb/March

I know this is awkward and I can't upload the file

 

[Fluff]

Duplicate to: Changing conditional formatting for Quarters/months

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread.