Conditional Formatting - using an "OR"

Sean Corcoran

I have 5 fields that I want to make sure are filled in "NOT BLANK" for each new row that is added to a project plan. I would like to turn turn the row RED if any of the 5 fields are blank. You can add a second or third condition using "AND" but in this case it would be "OR" "Blank". is this possible?

Paul Newcome

You would need to insert a helper column (that can then be hidden to keep the sheet looking clean that will house a formula to output something specific on rows where there is a blank. You would then set up your conditional formatting based on this helper column.

=IF(OR(ColumnA = "", ColumnB = "", ColumnC = ""), "output")

Sean Corcoran

@Paul Newcome thanks for help and formula

Paul Newcome

You would need to insert a helper column (that can then be hidden to keep the sheet looking clean that will house a formula to output something specific on rows where there is a blank. You would then set up your conditional formatting based on this helper column.

=IF(OR(ColumnA = "", ColumnB = "", ColumnC = ""), "output")

Sean Corcoran

@Paul Newcome thanks for help and formula

Paul Newcome

Happy to help. 👍️