Results 1 to 4 of 4

conditional formatting with IF/AND function

Threaded View

mishka02 conditional formatting with... 03-09-2012, 01:17 AM
DGagnon Re: conditional formatting... 03-09-2012, 01:23 AM
mishka02 Re: conditional formatting... 03-09-2012, 01:34 AM
DGagnon Re: conditional formatting... 03-09-2012, 01:36 AM
  1. 03-09-2012, 01:17 AM #1
    mishka02 is offline
    Registered User
    Join Date
    03-09-2012
    Location
    Louisiana
    MS-Off Ver
    Excel 2000
    Posts
    2

    conditional formatting with IF/AND function

    I'm working on a project and need to add conditional formatting for a range of cells. My goal was to have a formula that would first, determine if the cell had text and second, if text is present then determine if the date in a particular cell plus 7 is less than or equal to the current date. Lastly, I need the full row of that cell to be highlighted. I put together a few formulas but keep getting errors from excel and at this point I'm starting to wonder if it's not possible.

    The last formula I worked up was:

    =IF(istext(A1),if(and(d1:7<TODAY)),""

    I realize there are a ton of inaccuracies within the formula though it was a very rough work in progress.


    Can someone please help me with this or tell me if it is even possible?
    Attached Files Attached Files
    Last edited by mishka02; 03-09-2012 at 01:35 AM.
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1