+ Reply to Thread
Results 1 to 7 of 7

Conditionally Format Row based on Multiple Cells in Row

  1. #1
    Registered User
    Join Date
    09-27-2007
    Posts
    7

    Conditionally Format Row based on Multiple Cells in Row

    Hey everyone,

    Hopefully I can explain this correctly here.

    I am creating a Job Book which has all the pertinent information connected to it. I want to have a formula so that if the invoice date is over 30 days old, then the entire row will turn red. However, it should not turn red if there is a date paid entered (meaning it is complete).

    Any help would be great.


    I attached the file here. I want the entire row red if the value in Column K (Invoice Date) is over 30 days old and there is nothing listed in Column L.


    Thanks,

    -Todd DeBacker
    Attached Files Attached Files

  2. #2
    Forum Contributor VBA Noob's Avatar
    Join Date
    04-25-2006
    Location
    London, England
    MS-Off Ver
    xl03 & xl 07(Jan 09)
    Posts
    11,988
    Please read forum rules below and then amend your title

    VBA Noob
    _________________________________________


    Credo Elvem ipsum etian vivere
    _________________________________________
    A message for cross posters

    Please remember to wrap code.

    Forum Rules

    Please add to your signature if you found this link helpful. Excel links !!!

  3. #3
    Forum Expert dominicb's Avatar
    Join Date
    01-25-2005
    Location
    Lancashire, England
    MS-Off Ver
    MS Office 2000, 2003, 2007 & 2016 365
    Posts
    4,867

    Smile

    Good afternoon todd.debacker

    ...and welcome to the forum!"

    You need to use conditional formatting (Format > Conditional Formatting), set FormulaIs and use this formula :
    =AND(NOW()-$K1>30,$L1="")

    You can copy / paste special the format down to other rows.

    HTH

    DominicB
    Please familiarise yourself with the rules before posting. You can find them here.

  4. #4
    Registered User
    Join Date
    09-27-2007
    Posts
    7

    Its not Working

    I have it working.

    However, I want to be able to apply this rule to the entire spreadsheet, so that you can add rows and rows and
    it will always do this. I tried pasting the format to other cells and they immediately turned red. How can I have
    it display normally, until values for the row are entered?


    Is this possible?


    Thanks

    -Todd DeBacker
    Last edited by todd.debacker; 09-27-2007 at 12:32 PM.

  5. #5
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643
    Todd

    Did you test it?

    If so how?

  6. #6
    Registered User
    Join Date
    09-27-2007
    Posts
    7

    If Statement?

    I think my final problem can be solved with an If statement.

    Is there anyone that can help me do this, Im still learning

  7. #7
    Forum Expert dominicb's Avatar
    Join Date
    01-25-2005
    Location
    Lancashire, England
    MS-Off Ver
    MS Office 2000, 2003, 2007 & 2016 365
    Posts
    4,867

    Smile

    Hi todd.debacker

    I think my final problem can be solved with an If statement.
    No it can't. Formulae cannot affect worksheet formats. At all. Not even custom functions. It can be solved by a conditional format as shown above.

    Have a look at your file attached, which has the conditional format in place from rows 2 to 10.

    HTH

    DominicB
    Last edited by dominicb; 08-19-2008 at 04:30 AM.

+ 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