How to Apply Conditional Formatting Once All Cells in a Row Are Filled In

Hi! I’m trying to turn a single row green (using conditional formatting) ONLY IF all cells in that row are filled in (i.e., once the record is complete).

How can I do that?

hi @Rai_Cornell , welcome to the community

I suggest to count the columns. When a column contains content is seen as 1, if not nothing

When you add columns, you have to adapt the condition.

I hope it helps, cheers, Christiaan

1 Like

BRILLIANT!! That worked! Thank you so much, Christiaan! :slight_smile:

2 Likes

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.