+ Reply to Thread
Results 1 to 5 of 5

Incorrect Formula - conditional formatting

  1. 09-10-2013, 07:17 AM #1
    mahowarth is offline
    Registered User
    Join Date
    05-01-2013
    Location
    Brisbane
    MS-Off Ver
    Office 365
    Posts
    16

    Incorrect Formula - conditional formatting

    Hi there,

    I downloaded a excel template to assist with a project I'm working on.
    I've attached the template.

    My question is regarding the conditional formatting - as you can see in Cell H11 the start date is 22nd July but the blue shading starts from the H column which is 16th July.
    I'm trying to determine if the Conditional formatting formula is correct?

    Thanks!

    Regards
    MarkTemplate1.xlsx
    Reply With QuoteRegister To Reply
  2. 09-10-2013, 08:37 AM #2
    martindwilson is offline
    Forum Expert martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: Incorrect Formula - conditional formatting

    thats correct since 22 july is in the week commencing 16th july
    "Unless otherwise stated all my comments are directed at OP"

    Mojito connoisseur and now happily retired
    where does code go ?
    look here
    how to insert code

    how to enter array formula
    why use -- in sumproduct
    recommended reading
    wiki Mojito

    how to say no convincingly

    most important thing you need
    Martin Wilson: SPV
    and RSMBC
    Reply With QuoteRegister To Reply
  3. 09-10-2013, 05:31 PM #3
    mahowarth is offline
    Registered User
    Join Date
    05-01-2013
    Location
    Brisbane
    MS-Off Ver
    Office 365
    Posts
    16

    Re: Incorrect Formula - conditional formatting

    Thanks Martin.

    Can you assist with the conditional formatting code so that it only starts the shading between the start and end date for that row?

    Regards,
    Mark
    Reply With QuoteRegister To Reply
  4. 09-10-2013, 06:04 PM #4
    martindwilson is offline
    Forum Expert martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: Incorrect Formula - conditional formatting

    how? you can't colour 1/7 of a cell
    Reply With QuoteRegister To Reply
  5. 09-10-2013, 08:27 PM #5
    newdoverman is offline
    Forum Expert newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,330

    Re: Incorrect Formula - conditional formatting

    If you want the chart in a daily instead of weekly presentation, this is what you will have to do or something similar.
    Attached Files Attached Files
    <---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.
    Ron W
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Conditional Formatting - Using Formula - Help, can't get the formatting to work :(
    By LittlePhoenix in forum Excel General
    Replies: 1
    Last Post: 07-19-2012, 05:37 AM
  2. conditional formatting displays incorrect value when time is 12:00
    By moonbecky in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-28-2008, 12:44 PM
  3. How do I do a complex conditional in a conditional formatting formula
    By Ray Stevens in forum Excel General
    Replies: 6
    Last Post: 03-12-2006, 06:30 PM
  4. formatting is incorrect when viewing in different zoom except for 75%
    By Henry Chan in forum Excel General
    Replies: 3
    Last Post: 07-22-2005, 08:05 PM
  5. Incorrect Date formatting
    By dionne_w in forum Excel General
    Replies: 2
    Last Post: 02-22-2005, 06:06 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1