I have a leading column A with some information in it, and columns B, C, D and G with data that must be filled in for support.
I want to have a conditional format to highlight those other cells, to remind the user that the information needs to be inputted and is currently missing.
Basically looking for like: Highlight IF NOT(ISBLANK(A1) AND ISBLANK(SELF)
I can do that one-at-a-time for the columns, and the condition is =AND(NOT(ISBLANK($A1)),ISBLANK($B1))
Is there a way I can mass-apply the condition to cover *Any* columns included in the Conditional Formatting selection? I don't want to edit 3 or 5 or 10 conditions if the required columns change later on.
I want to have a conditional format to highlight those other cells, to remind the user that the information needs to be inputted and is currently missing.
Basically looking for like: Highlight IF NOT(ISBLANK(A1) AND ISBLANK(SELF)
I can do that one-at-a-time for the columns, and the condition is =AND(NOT(ISBLANK($A1)),ISBLANK($B1))
Is there a way I can mass-apply the condition to cover *Any* columns included in the Conditional Formatting selection? I don't want to edit 3 or 5 or 10 conditions if the required columns change later on.