Results 1 to 2 of 2
  1. #1
    2 Star Lounger
    Join Date
    Jun 2011
    Posts
    173
    Thanks
    56
    Thanked 0 Times in 0 Posts

    Mandatory entry in column if other column values less than 24

    Hello Experts!

    I have column C which contains hours on and in column O is blank for code entery. I need if column c Values less then 24 so a popup comes you need to enter the code in the column O cell no .

  2. #2
    Super Moderator RetiredGeek's Avatar
    Join Date
    Mar 2004
    Location
    Manning, South Carolina
    Posts
    6,403
    Thanks
    208
    Thanked 833 Times in 766 Posts
    Farrukh,

    Have you considered using conditional formatting vs a popup? It is a lot less intrusive when entering data.
    ConditionalFormatting.JPG

    Here's the formula so it's easire to read: =AND(NOT(ISBLANK($C1)),$C1<24)
    HTH
    May the Forces of good computing be with you!

    RG

    VBA Rules!

    My Systems: Desktop Specs
    Laptop Specs


Posting Permissions

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