+ Reply to Thread
Results 1 to 2 of 2

I am using the formula below below but only green color in cell BK=59 not BK=65

  1. #1
    Registered User
    Join Date
    04-20-2013
    Location
    Sweden
    MS-Off Ver
    Excel 2007
    Posts
    4

    I am using the formula below below but only green color in cell BK=59 not BK=65

    Hi !

    When I fill in date for my project in my example H=65 (22-Aug), I=65 (23-Aug) I want to use “Conditional Formatting” to fill in color in two cells BK=59 and BK=65.
    I am using the formula below see picture below but only green color in cell BK=59 not BK=65
    Have some one some tips what to do ?

    Rule (=AND(COUNT($H65:$I65)=2;J$5>=$H65;J$5<=$I65))
    Conditional Formatting Rules Manager (=$J$59:$GP$59;$J$65:$GP$65)

    Br
    Lars-Erik

    Exel Formula.jpg

  2. #2
    Forum Expert etaf's Avatar
    Join Date
    10-22-2004
    Location
    Wittering, West Sussex, UK
    MS-Off Ver
    365 (Mac OSX) (16.83 (24031120))
    Posts
    8,686

    Re: I am using the formula below below but only green color in cell BK=59 not BK=65

    i'm a little lost on the explanation here

    you want to apply the colour to BK59 and BK65 Only

    so if you highlight/select both the Bk59 and BK65 - that will be the applies to range
    and then use
    (=AND(COUNT($H65:$I65)=2;J$5>=$H65;J$5<=$I65))
    what colour condition is that for ? green

    rather than attach an image attach the actual spreadsheet - just make sure its all dummy data and can be on a public forum
    Wayne
    if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here

    If you have a solution to your thread - Please mark your thread solved do the following: >
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

+ 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. Replies: 12
    Last Post: 09-18-2012, 03:13 PM
  2. Replies: 1
    Last Post: 03-12-2008, 06:35 PM
  3. Change the cell color from green to red
    By ljenning in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-29-2007, 03:17 PM
  4. Change a cell color based on a certain value (green or red)
    By Ugbe in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-23-2006, 07:22 AM
  5. [SOLVED] can macros change cell color daily, i.e. green to red everyday?
    By Jim Nicholls in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-06-2005, 07:05 AM

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