+ Reply to Thread
Results 1 to 3 of 3

Conditional formatting: two different fields affect one cells formatting for a date.

  1. #1
    Registered User
    Join Date
    02-10-2012
    Location
    Cowtown Canada
    MS-Off Ver
    Excel 2010
    Posts
    50

    Conditional formatting: two different fields affect one cells formatting for a date.

    Hello.

    A little background on what i am doing. I have a spreadsheet that tracks when i have blown the dust out of our computers. I have set up conditional formatting so that the text turns red after 300 days and the cell turns yellow after 600 days. However, some computers are in high dust environments. I would like the spreadsheet to tell me to blow the dust out of these sooner. Please see the attached sheet.

    Thanks guys.


    dust 1.xlsx

  2. #2
    Valued Forum Contributor
    Join Date
    05-13-2010
    Location
    Belo Horizonte, Brazil
    MS-Off Ver
    Excel 2003; 2007
    Posts
    441

    Re: Conditional formatting: two different fields affect one cells formatting for a date.

    gluktar, Good Afternoon.

    You can have two different system at same time.

    a) Normal environment.....N...YELLOW...>=600...RED...>=300

    b) High dust environment..Y...YELLOW...>=200...RED...>=100

    Do this at Conditional formating:

    At A2 use this:
    First condition....:=OR(AND(B2="Y",TODAY()-A2>=200),AND(B2="N",TODAY()-A2>=600)

    Second condition:=OR(AND(B2="Y",TODAY()-A2>=100),AND(B2="N",TODAY()-A2>=300)

    Is it what you desire?
    I hope it helps.
    ...If my answer helped you, Please, click on. * Add Reputation (at left)

    Best regards.
    Marcílio Lobão

  3. #3
    Registered User
    Join Date
    02-10-2012
    Location
    Cowtown Canada
    MS-Off Ver
    Excel 2010
    Posts
    50

    Re: Conditional formatting: two different fields affect one cells formatting for a date.

    You NAILED IT! Thanks.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Conditional Formatting of date cells
    By jrlafrance in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-25-2013, 01:37 PM
  2. [SOLVED] Conditional Formatting / Macro to affect specific string within a cell
    By xandermacleod in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-16-2012, 02:06 PM
  3. Conditional Formatting-Need one cell to affect another
    By billdebw in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-25-2009, 10:12 AM
  4. Conditional Formatting on Date cells
    By modest_16081982 in forum Excel General
    Replies: 2
    Last Post: 11-05-2008, 05:32 PM
  5. [SOLVED] Can a conditional formatting result affect another cell or cells
    By marseans in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-23-2005, 02:20 PM

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