Conditional Formatting for RAG Rating of Due & Overdue Works

i have a work tracking sheet. in sheet EA cell S14 is yellow. i want that it should show up red when it is blank on the date pass. for example S14 work had to be done on 27th feb. but still that work is not done. i want that this is late and not done so this need to be red. if the work gets complete on 28th feb or today that will become red(formula already applied) but now i want that if that not get done on that particular day. then also it should show up red even if done late and even if is empty. for all late cells also like v17, v18 and many more.

please do this. i am hoping that this will also be get solved

here is the link of file.
https://docs.google.com/spreadsheets...gid=1924994592

Please upload a workbook to this forum. It is always easier to advise if we can see your request in its context.

Show a before and after situation with manually calculated results, explaining which information is data and which is results, and if it's not blindingly obvious how you have arrived at your results some explanatory notes as well.

To upload a file click the Go Advanced button at the foot of your post, look underneath the post area for the Manage Attachments section and take it from there.

Is this a Google Sheets doc rather than an Excel workbook.

Administrative Note:

We would very much like to help you with your query, however the thread title does not really convey what your request is about.

Please take a moment to amend your thread title. Make sure that the title properly explains your request. Your title should be explicit and not be generic (this includes function names used without an indication of what you are trying to achieve).

Please see Forum Rule #1 about proper thread titles and adjust accordingly. To edit the thread title, open the original post to edit and then click on Go Advanced (bottom right) to access the area where you can edit your title.

(Note: this change is not optional. No help to be offered until this moderation request has been fulfilled.)

first of all thanks for your reply. this is google sheet workbook so i didn't find a way how to upload. so anyone can access the file by pressing the link i have shared.
https://docs.google.com/spreadsheets...gid=1924994592

here is my query.

R12 is the date on which any work was planned to be done. but in fact the work got completed on march 1st 2019 (S12). when we enter "y" in T12. so when any work gets completed late it starts to show red and if work gets completed on planned date it becomes white.(normal cell)

O 12 is planned date for the work(B12). P12 is actual date, it comes when we fill "y" in Q12. still the work is pending and this is showing yellow.
but the planned date has gone so i want that P12 should be red even if we dont write "y" in Q12.

i have included an result sheet in my workbook. what i want.

Administrative Note:

Sorry, but your post does not comply with Rule #6 of our Forum RULES:

Please do not ignore requests by Administrators, Moderators and senior forum members regarding forum rules.

I am waiting for you to change your title as requested. Something like this: "Conditional Formatting for RAG Rating of Due & Overdue Works".

If you are unclear about the request or instruction, then send a private message to me asking for clarification.

All Participants:

Please do not post a reply in a thread where a Moderator or Administrator has requested an action that has not yet been complied with (e.g. title change, code tags requested, etc.). Thanks.

As two days have passed an you may no longer be able to edit your opening post, I have changed the title for you. Please make sure that you use more descriptive titles in future.

You've been asked to upload a workbook here.

Unfortunately the attachment icon doesn't work at the moment, so to attach an Excel file you have to do the following: just before posting, scroll down to Go Advanced and then scroll down to Manage Attachments. Now follow the instructions at the top of that screen.

In post #8 you were told how to upload the file. I suggest you follow that advice.

In #10 Pepe was telling you why we require files uploade here. He wan't saying that a google product was unsafe.

Originally Posted by akshay6s

yeah i followed that but google sheet can't be uploaded through that. only excel file can be uploaded.

In that case zip the file and upload