• Conditional Format if Cell is Blank

    Author
    Topic
    #487417

    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.

    32919-3

    Regards Kerry:rolleyes:

    Viewing 1 reply thread
    Author
    Replies
    • #1369944

      Kerry,

      Base your conditional format on this formula: [noparse]=AND(B2″”,C2=””)[/noparse].
      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.
      32920-ConditionalFmt
      HTH :cheers:

      May the Forces of good computing be with you!

      RG

      PowerShell & VBA Rule!
      Computer Specs

    • #1369954

      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.
      [noparse]=AND(B2″”,CELL(“Format”,C2)=”D4″,ISNUMBER(C2))[/noparse]
      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.
      [noparse]=C2″”[/noparse]

      32922-New-and-Improved-ConditionalFmt

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

      HTH :cheers:

      May the Forces of good computing be with you!

      RG

      PowerShell & VBA Rule!
      Computer Specs

    Viewing 1 reply thread
    Reply To: Conditional Format if Cell is Blank

    You can use BBCodes to format your content.
    Your account can't use all available BBCodes, they will be stripped before saving.

    Your information: