Results 1 to 1 of 1

Conditional Formating

Threaded View

Myroslava Conditional Formating 05-06-2014, 11:55 AM
  1. #1
    Registered User
    Join Date
    05-06-2014
    Location
    Plymouth, MN
    MS-Off Ver
    Excel 2010
    Posts
    1

    Conditional Formating

    Please help me with the project. Log Improvement: Create conditional formatting that turns information red if within 10 days of reaching processing requirement deadline.
    (30 days to process C&S, 60 days to process M&R)

    M&R – 60 CAL 50 red
    C&S 30 cal 20 red *Cal days open
    It needs something like :
    IF: M&R = OPEN = CALDAYS OPEN (50-60) = condit.Formatting red
    C&S = OPEN = CAL DAYS OPEN( 20-30) = condit.formatting red

    Thanks,
    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. Replies: 5
    Last Post: 03-14-2014, 04:03 AM
  2. Replies: 4
    Last Post: 01-23-2014, 10:14 AM
  3. Replies: 6
    Last Post: 08-14-2006, 05:00 PM
  4. Replies: 2
    Last Post: 03-27-2006, 12:10 PM
  5. Install dates formating using conditional formating?
    By Jerry Eggleston in forum Excel General
    Replies: 2
    Last Post: 11-09-2005, 01:49 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