Results 1 to 9 of 9

Thread: conditional formatting

  1. #1
    Seeker DALE1612's Avatar
    Join Date
    Sep 2015
    Posts
    15
    Articles
    0
    Excel Version
    2007

    conditional formatting



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hell o guys, I am having trouble with setting conditional formatting that falls between two dates. I dont need to see a red cell at A2, and I do need to see red cells at A11,12 according to the the dates set out in "C" & "D"

    I have had add a minus 1 to the formula to hightlight the cells that fall between the dates other wise the column goes red and leaves the other cells without any fill. which is the reverse of what is required. I am not sure if this is the correct way to set the formula out or not? the formula seems to be straight forward but this is a bit baffleing. I att a srceen print to show what is happening. Any would be appreciated.

    Thank you.
    Attached Files Attached Files

  2. #2
    Wizard Pecoflyer's Avatar
    Join Date
    Oct 2011
    Location
    Brussels Belgium
    Posts
    1,544
    Articles
    0
    Excel Version
    2010 on Xubuntu
    Hi
    this is an Excei forum, and you have posted a docx document? ( I haven't opened it)
    Thank you Ken for this secure forum.

  3. #3
    Seeker DALE1612's Avatar
    Join Date
    Sep 2015
    Posts
    15
    Articles
    0
    Excel Version
    2007
    Hi Pecoflyer, if you had opened the Att: you would have noticed the query I posted concerned Excel, but thx for your response.

  4. #4
    Wizard Pecoflyer's Avatar
    Join Date
    Oct 2011
    Location
    Brussels Belgium
    Posts
    1,544
    Articles
    0
    Excel Version
    2010 on Xubuntu
    How do you expect us to work on the image of a sheet? Post the sheet so we can work on it
    Thank you Ken for this secure forum.

  5. #5
    Seeker DALE1612's Avatar
    Join Date
    Sep 2015
    Posts
    15
    Articles
    0
    Excel Version
    2007
    as requested ATT: worksheet
    Attached Files Attached Files

  6. #6
    Magician navic's Avatar
    Join Date
    Aug 2013
    Location
    Europe, Croatia
    Posts
    798
    Articles
    0
    Excel Version
    Excel 2013
    Select eg. A1:A20 and apply Conditional Formatting
    Code:
    =AND($A1<>"";$A1>=$C$3;$A1<=$D$3)
    My personal Web Excel Tutorials
    Attention! In the formulas as a delimiter I use a semicolon (; ) if you using my formula, then perhaps you need to use a comma (,)
    Also for a decimal number I use a comma (,) you may need to use point (.) instead of

  7. #7
    Seeker DALE1612's Avatar
    Join Date
    Sep 2015
    Posts
    15
    Articles
    0
    Excel Version
    2007
    thanks Navic for your input. I have tested the formula. There still remains an issue as the column fill as itcontinues to fill outside of the dates set in "C"&"D".

    I need the fill to operate when the dates in "A" are within the dates set in "C"&"D" Hope this helps. I have att: a new example.
    Attached Files Attached Files

  8. #8
    Wizard Pecoflyer's Avatar
    Join Date
    Oct 2011
    Location
    Brussels Belgium
    Posts
    1,544
    Articles
    0
    Excel Version
    2010 on Xubuntu
    Your formula in the sheet you posted

    =AND($A1<>"",$A2>=$A2,$C$3<=$D$3)

    Navic's ( perfectly correct) formula
    =AND($A1<>"",$A1>=$C$3,$A1<=$D$3)

    See the difference?

    When entering formula in CF do not use right or left arrow, it messes your formula up
    Thank you Ken for this secure forum.

  9. #9
    Seeker DALE1612's Avatar
    Join Date
    Sep 2015
    Posts
    15
    Articles
    0
    Excel Version
    2007
    Thank you guys for your help and assistance. This now works as designed.

    Thanks again.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •