Advertisement
If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)
Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie
Hi there,
There is an issue with role permissions that is being worked on at the moment.
If you are having trouble with access or permissions on regional forums please post here to get access: https://www.boards.ie/discussion/2058365403/you-do-not-have-permission-for-that#latest

Excel Spreadsheet

  • 25-01-2008 12:18pm
    #1
    Baldie
    Registered Users, Registered Users 2 Posts: 1,198 ✭✭✭


    I am creating a spreadsheet for Customer Returns. How do I format a date cell to change colour, when the date in the cell is older than 30 days old?


Comments

  • #2
    meditraitor
    Closed Accounts Posts: 5,207 ✭✭✭meditraitor


    http://en.allexperts.com/q/Excel-1059/cell-fill-colors.htm
    Have a look at this and change to suit, hope it helps(this one is for changes in % (but date should be possible)
    Select the cells you wish to have formatted this way. Then with the cells selected go to the Excel menu and select "Format" then "Conditional Formatting..."

    Now you will see drop down boxes to select. The first one on the Left should read "Cell Value Is", then the next one to the Right should read "Between" then the next open box to the Right type in a 0 then in the next box to the Right type in .10 now click the "Format..." button and select the "Pattern" tab and then select the "Green" color and then click "OK" now click the "Add>>" button.

    Now we will repeat the same process for the next color. You will see drop down boxes to select. The first one on the Left should read "Cell Value Is", then the next one to the Right should read "Between" then the next open box to the Right type in .10 then in the next box to the Right type in .109 now click the "Format..." button and select the "Pattern" tab and then select the "Yellow" color and then click "OK"

    Now we will repeat a similar process for the final color, but pay attention to the slight change. You will see drop down boxes to select. The first one on the Left should read "Cell Value Is" then next one to the Right should read

    "Greater Than"

    then the next open box to the Right type in .109 now click the "Format..." button and select the "Pattern" tab and then select the "Red" color and then click "OK" Now click "OK" again.

    Now select a cell you formatted this way and type in percentage numbers from 0 to 10% and 10.1% to 10.9% and greater than 10.9% and you will see the colors change from Green to Yellow to Red.

    I have made an example workbook of this process that you can download or view online at.

    http://www.squish.com/cloverleaf/larry.xls

    Press the F9 key to see the numbers and colors change.

    Thanks


Advertisement