Results 1 to 11 of 11

2 Conditional formats but only 1 working

Threaded View

  1. #4
    Forum Expert etaf's Avatar
    Join Date
    10-22-2004
    Location
    Wittering, West Sussex, UK
    MS-Off Ver
    365 (Mac OSX) (16.92 (24120731))
    Posts
    9,115

    Re: 2 Conditional formats but only 1 working

    i have added the three rules
    are you using excel 2003

    and used today

    so if in the cell D8

    you put

    =today()-xx
    where xx is the number of days you want to go back

    so =today()-90
    =today()-60

    see if that works OK

    does not need to test A5 , unless you need that as part of the test
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] PasteSpecial with number formats but without conditional formats or borders
    By bodhi808 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-18-2013, 09:58 AM
  2. [SOLVED] Conditional Formats .activate not working in Personal.xls
    By dlsmith36 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-25-2013, 03:57 PM
  3. Conditional formats from 2007 not working in 2010
    By roskib in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-17-2013, 07:10 AM
  4. Working with Condtitional formats and dates
    By ibabs in forum Excel General
    Replies: 2
    Last Post: 06-25-2009, 02:40 PM
  5. Cell formats not working
    By wellscrambled in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-14-2008, 12:44 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