Results 1 to 3 of 3
  1. #1
    4 Star Lounger
    Join Date
    Apr 2002
    Location
    Northern Territory, Australia
    Posts
    471
    Thanks
    16
    Thanked 0 Times in 0 Posts

    Conditional Format if Cell is Blank

    Can someone assist me with this conditional format please?

    If there is a name in (B) "Acting" then there must be a date in (c) "Date Acting to" otherwise highlight C cell red.


    3.pdf

    Regards Kerry

  2. #2
    Super Moderator RetiredGeek's Avatar
    Join Date
    Mar 2004
    Location
    Manning, South Carolina
    Posts
    9,434
    Thanks
    372
    Thanked 1,457 Times in 1,326 Posts
    Kerry,

    Base your conditional format on this formula: =AND(B2<>"",C2="").
    Note: to enter the formula select all the cells in Column C you want the format to apply to don't worry it will auto adjust the references.
    ConditionalFmt.PNG
    HTH
    May the Forces of good computing be with you!

    RG

    PowerShell & VBA Rule!

    My Systems: Desktop Specs
    Laptop Specs

  3. #3
    Super Moderator RetiredGeek's Avatar
    Join Date
    Mar 2004
    Location
    Manning, South Carolina
    Posts
    9,434
    Thanks
    372
    Thanked 1,457 Times in 1,326 Posts
    Kerry,

    Here's a New and Improved set of rules that will check not only if column C is missing a value but also if it contains a number and that that number is a date! This relies on 2 rules.

    Rule 1: Check to see if it is a good record e.g. B1 isn't blank and C1 contains a number that is also a date.
    =AND(B2<>"",CELL("Format",C2)="D4",ISNUMBER(C2))
    You'll notice from the graphic that this rule sets the color of column C to WHITE since everything is ok and it is also set to stop processing since you need go no further!

    Rule 2: Checks to see if B2 isn't blank if it is it is a bad record since you got past rule 1 so it sets C2 to RED.
    =C2<>""

    New and Improved ConditionalFmt.PNG

    Note: cols D & E were just there to help me work out the logic and are not necessary for the formulas to work.

    HTH
    May the Forces of good computing be with you!

    RG

    PowerShell & VBA Rule!

    My Systems: Desktop Specs
    Laptop Specs

  4. The Following User Says Thank You to RetiredGeek For This Useful Post:

    kerryg (2013-01-22)

Posting Permissions

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