Results 1 to 2 of 2

Thread: a little bit of help

  1. #1

    a little bit of help



    Register for a FREE account, and/
    or Log in to avoid these ads!

    hello, my name is Radu and recently i've changed my job to a firm where i have to use allot of excel sheets.
    my question, if you could give me a helping hand is this:

    on a sheet, i have to ad up dates. Ex: 02.02.2017.

    in a top right corner, in a cell i've aded :A1 =TODAY()

    eache cell that i enter dates, i want it to change the fill collor like this: if it is <A1-90 turn green ; if > A1-90 turn red
    if no date is enter the cell has to remain Blank.

    I've manage to do this with Conditional formating but, every day i open the sheet is the same collors. no change at all

    How can i do a formula to be aplied All day, every cell.....

    thx, radu

  2. #2
    Administrator Pecoflyer's Avatar
    Join Date
    Oct 2011
    Location
    Brussels Belgium
    Posts
    1,680
    Articles
    0
    Excel Version
    2010 on Xubuntu
    Thank you Ken for this secure forum.

Posting Permissions

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