+ Reply to Thread
Results 1 to 3 of 3

Conditional Formatting Macro

  1. #1
    Registered User
    Join Date
    12-28-2006
    Posts
    42

    Conditional Formatting Macro

    I'm back again. I'm trying to set up a conditional formatting macro to evaluate 2 pieces of data in each row and set the cell background color based on the value of those 2 cells if it can be done. I can get it to do it with 1 condition, but not both.

    What I have is a spreadsheet with several hundred rows, and columns A-N. Column I is called LOB and column M is called Date Added. I need the macro to see if the date in the Date Added column for each row is less than todays date, and then see if the data in the LOB column for each row is equal to either Auto or Home. If the date is less than today's date and the LOB equals Auto or Home, I want it to change the cell color for that row, columns A-N to a specific color. If all of the above criteria aren't met, I don't want it to do anything to the row.

    Does that make sense? Thanks in Advance!

  2. #2
    Forum Contributor
    Join Date
    12-12-2005
    Posts
    667
    Rather than using a macro you should use conditional formatting that achieves the same end much more simply!
    Best regards,

    Ray

  3. #3
    Registered User
    Join Date
    12-28-2006
    Posts
    42
    I tried using the conditional formatting operation to get the desired result, but as mentioned above, I'm having issues getting it to work properly. Sorry for being such a newbie.

+ 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