I want to highlight any blank input cell in a row if the row is labeled as completed in column B. There are several columns with information being entered in them and I would like to use this as a flag for accidentally leaving a blank when completing a row.

I tried entering formula below for conditional formatting rule, but it didn't work.

=AND($B2="completed", "")

You're on the right track! The first condition in your AND function is correct. But for the second one, you need to specify which cell it should compare "" with. "" by itself is not a condition. Try this (assuming your conditional format is being applied to a range of cells starting at cell A2):

=AND($B2="completed", A2="")

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.