+ Reply to Thread
Results 1 to 2 of 2

conditional format wont run 2 formats at once

Hybrid View

  1. #1
    Registered User
    Join Date
    12-29-2005
    Posts
    90

    conditional format wont run 2 formats at once

    im trying to get 2 conditional formats to run at once but cant seen to get it to work, i've set it up to do the following

    condition 1 is set to cell value is - - equal to - - ="removed" format as pattern with a cross hatch patern selected

    condition 2 is set to formula is - - =ifCU12<>""+CU12<cv12 - - format as font colour red

    where cu 12 contains a date i've put in manually and cv 12 contains the formula =today()

    the cell with the conditional format would be blank, contain a date or contain the word "removed" without the quotes

    i can get either of them to work individually but not together

    what am i doing wrong?

  2. #2
    Forum Contributor
    Join Date
    10-27-2006
    Location
    United Kingdom
    MS-Off Ver
    EXCEL 2003 (2007 at home)
    Posts
    517
    Try

    AND(CU12<>"",CU12<cv12)

    Mark

+ 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