Conditional fomatting based on date

[sambashivamk]

Hello,

I need this report to be coloured based on the criteria given in sample file.

Note:The cells which are highlighted in color for each dates in the file are manual, the same needs to be worked in conditional formatting based on the date updated in the cell A9.

Requirement is given in the sample sheet itself. Pls help.

 

[NARAYANK991]

Hi ,

Please upload your file.

Narayan

 

[sambashivamk]

sorry..i was uploaded earlier..due to some issues it didnt get upaloaded...
Here the uploaded files.

 

[Khalid NGO]

Hi,

Please check if it is okay.

Regards,

 

[sambashivamk]

Wow...this is awesome..Thanks a lot for ur help

 

[Khalid NGO]

Wow...this is awesome..Thanks a lot for ur help

Thanks dear for the feedback.
Keep visiting.

 

[sambashivamk]

1.In ops column it should exclude weekends. Here I need 2 days to be highlighted which is already done by you, but for eg. If 17th is Friday then it should highlight only 17th and 20th (next working day) or if 17th is Saturday then it should highlight color for 20th and 21st.

2.In Result column should highlight highlighted of the 2nd ops day +1 till month end and it should not highlight weekends.

3.in Interview column 3rd highlighted day should be next day of the 2nd ops day (this was not informed in my earlier requirement)

 

[sambashivamk]

1.In ops column it should exclude weekends. Here I need 2 days to be highlighted which is already done by you, but for eg. If 17th is Friday then it should highlight only 17th and 20th (next working day) or if 17th is Saturday then it should highlight color for 20th and 21st.

2.In Result column should highlight highlighted of the 2nd ops day +1 till month end and it should not highlight weekends.

3.in Interview column 3rd highlighted day should be next day of the 2nd ops day (this was not informed in my earlier requirement)

Hope this cand be done by using weekdays formula but i dont know how to apply this..pls help..thnx in advance.

 

[Khalid NGO]

Hope this cand be done by using weekdays formula but i dont know how to apply this..pls help..thnx in advance.

Sorry, I didn't read the complete conditions.
I have made some changes to automate date and days, so you don't need to manually enter days name.

OPS:
Friday is on 14th and on 21st; not 17th as you mentioned.
Please confirm what is your desire result?

Will move to the next, once I get your point completely for OPS.

Regards,

 

[sambashivamk]

that is the just example i have given...here incase of weekedns then cell color should be shifted to next working day. its required only for OPS and Resulst column.Thanks

 

[Khalid NGO]

Hi,

I am still not getting what you are looking for, and also bit busy due to Friday.

See the file, check with various months and comment.

Regards,