Advertisement
Help Keep Boards Alive. Support us by going ad free today. See here: https://subscriptions.boards.ie/.
If we do not hit our goal we will be forced to close the site.

Current status: https://keepboardsalive.com/

Annual subs are best for most impact. If you are still undecided on going Ad Free - you can also donate using the Paypal Donate option. All contribution helps. Thank you.
https://www.boards.ie/group/1878-subscribers-forum

Private Group for paid up members of Boards.ie. Join the club.
Hi all, please see this major site announcement: https://www.boards.ie/discussion/2058427594/boards-ie-2026

Help with Excel Formula

  • 16-02-2010 02:40PM
    #1
    Closed Accounts Posts: 3


    Hi All.

    Don't know that this is the right place on the forum to ask the question but I can't find anywhere else and I'm REALLY stuck...

    I'm using excel 2007 and I'm trying to get cells to change color but I can't figure out what forumla to use in the conditional formatting section.

    What I want to convert to a proper excel formula is:
    • if the cell date is less than or equal to 28days PASSED today turn cell red
    • if the cell date is less than or equal to 56 days PASSED today turn cell amber
    • if the cell date is greater than or equal to 57 days PASSED today leave cell white.
    if anyone can help i'd really appreciate it. i'm tearing my hair out and no other specialist forms are much help.

    D


Comments

  • Registered Users, Registered Users 2 Posts: 490 ✭✭Pablod


    use conditional formatting
    in excel 2007 conditional formatting is not on the toolbar as default

    Right click on the toolbar and 'customize quick access toolbar'
    find 'conditional formatting in all commands and add this to your quick access toolbar

    Highlight the cells you want to apply your formula to,
    Then select the conditional formatting from the toolbar and you can set the colour of the cell to change based on your formula
    This should do the trick ;)


  • Technology & Internet Moderators Posts: 28,863 Mod ✭✭✭✭oscarBravo


    Moved from Open Source.


  • Registered Users, Registered Users 2 Posts: 5,067 ✭✭✭homer911


    Example Attached

    Conditional Formatting is on the Home Menu


Advertisement