+ Reply to Thread
Results 1 to 2 of 2

Advanced Conditional Formatting

  1. #1
    Registered User
    Join Date
    04-03-2012
    Location
    Dubai
    MS-Off Ver
    Excel 2007
    Posts
    2

    Advanced Conditional Formatting

    Hi,

    I have got this attachment. All the BE date will be expired within 45 days (G3). What I want is till 30 days I want Cell G3 on Green color. From 31st days till 45 days on orange color. After 46 days till 60 days on red color. After 60 days, black. Can someone help me on this??? please


    Sea & Air Deposit 2012.xlsx

  2. #2
    Forum Expert
    Join Date
    12-15-2009
    Location
    Traveling the world right now
    MS-Off Ver
    Microsoft Office 365
    Posts
    3,091

    Re: Advanced Conditional Formatting

    You need separate formula for each condition.
    Attached Files Attached Files
    My YouTube Channe (Learn Excel, SQL, Python development)l
    Check out my YouTube Channel

    My Travel YT Channel
    Check out my Travel YouTube Channel

+ 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