Table Conditional Format =ISBLANK ()

[Casedias]

Hello all,

I don't know a short & sweet way to pose this so here goes:

I have a table of information that already has mutiple conditions that are cell specific, but I also need to apply a condition to all cells so that if any cell is blank the condition changes for that cell only.

I know I can do each individual cell, but I really don't what to have to apply a rule to 3,000 cells.

Forever greatful t whoever answers this question.

[NBVC]

What's the current conditional format rule?

you may need to adjust by adding an AND()

e..g

=AND(A1<>"",your_current_formula)