+ Reply to Thread
Results 1 to 14 of 14

Conditional Formatting for RAG Rating of Due & Overdue Works

  1. #1
    Registered User
    Join Date
    08-07-2018
    Location
    india
    MS-Off Ver
    2007
    Posts
    83

    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
    Last edited by AliGW; 05-14-2019 at 12:26 AM.

  2. #2
    Forum Moderator Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Excel for Windows & Mac - all versions.
    Posts
    24,823

    Re: conditional formating

    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.
    Richard Buttrey

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  3. #3
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    Excel 2016 (Win 10 - Work) & 365 Subscription (Win 10 - Home)
    Posts
    25,389

    Re: conditional formating

    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.)
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!

    STOP PRESS: Forum Rules Updated September 2018! Please read them here.
    Are you new to Power Query and don't know what to do with the code you've been given? Have a look here.
    Don't forget to say "thank you" to those who have helped you in your thread. If you wish, you can also reward them by clicking on their reputation star bottom left.

  4. #4
    Registered User
    Join Date
    08-07-2018
    Location
    india
    MS-Off Ver
    2007
    Posts
    83

    Re: conditional formating

    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.
    Last edited by akshay6s; 05-13-2019 at 03:07 AM.

  5. #5
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    Excel 2016 (Win 10 - Work) & 365 Subscription (Win 10 - Home)
    Posts
    25,389

    Re: conditional formating

    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.
    Last edited by AliGW; 05-13-2019 at 03:26 AM.

  6. #6
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    Excel 2016 (Win 10 - Work) & 365 Subscription (Win 10 - Home)
    Posts
    25,389

    Re: onditional Formatting for RAG Rating of Due & Overdue Works

    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.

  7. #7
    Registered User
    Join Date
    08-07-2018
    Location
    india
    MS-Off Ver
    2007
    Posts
    83

    Re: onditional Formatting for RAG Rating of Due & Overdue Works

    ok thanks. still i dont have got any solution for my query. at least someone post a reply that it is possible or not. thanks again for your help that you have changed the title for me.

  8. #8
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    Excel 2016 (Win 10 - Work) & 365 Subscription (Win 10 - Home)
    Posts
    25,389

    Re: Conditional Formatting for RAG Rating of Due & Overdue Works

    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.

  9. #9
    Registered User
    Join Date
    08-07-2018
    Location
    india
    MS-Off Ver
    2007
    Posts
    83

    Re: Conditional Formatting for RAG Rating of Due & Overdue Works

    I have told so many times this is a google sheet. it can't get attached. link is only the access key. whats the problem accessing the file through link. is this really a help forum.

  10. #10
    Forum Moderator
    Join Date
    05-14-2009
    Location
    RDC
    MS-Off Ver
    Excel 2010 on Linux
    Posts
    6,731

    Re: Conditional Formatting for RAG Rating of Due & Overdue Works

    1.External links are notoriously unsafe
    2. Not all members can access them
    3.If for any reason the file is deleted the example is lost for our members depriving them of information to solve their problem.
    4; As your last post is the 81st you have already called upon the board many times, so you know help is provided

  11. #11
    Registered User
    Join Date
    08-07-2018
    Location
    india
    MS-Off Ver
    2007
    Posts
    83

    Re: Conditional Formatting for RAG Rating of Due & Overdue Works

    ok thanks for reply. i want to know how a google product can be unsafe. i have made that sheet easily accessible publicly. even some experts were there also on my sheet but they went off at once without saying anything. at least someone could explain that what is the problem or the query i am asking for is impossible for any reason. and it may be my 81st post i never refuse that. you are saying that i have called upon board many time. don't you call customer care if you face any problem regards any product. if someone is facing any problem then he/she will call board only, otherwise no one wants to waste his/her time.


    thanks again.

  12. #12
    Forum Moderator Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Excel for Windows & Mac - all versions.
    Posts
    24,823

    Re: Conditional Formatting for RAG Rating of Due & Overdue Works

    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.

  13. #13
    Registered User
    Join Date
    08-07-2018
    Location
    india
    MS-Off Ver
    2007
    Posts
    83

    Re: Conditional Formatting for RAG Rating of Due & Overdue Works

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

  14. #14
    Forum Moderator Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Excel for Windows & Mac - all versions.
    Posts
    24,823

    Re: Conditional Formatting for RAG Rating of Due & Overdue Works

    Quote Originally Posted by akshay6s View Post
    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

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1