Conditional Format

  • Hi All


    if a cell is not blank in a range from A10:A100 and a cell is blank in a range from B10:B100


    Any ideas how I would I use a conditional format to highlight the blank cells in the Range B10:B100


    Many Thanks

  • Hello,


    Select your range B10:B100 and while adding conditional formatting, you can insert the following formula


    Code
    =AND($A10<>"",$B10="")


    Hope this will help

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Smiley" icon, below, in the bottom right corner :)

  • Glad you could solve your problem ...:wink:


    Thanks for your Thanks ...AND for the Like ... :smile:

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Smiley" icon, below, in the bottom right corner :)

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!