Forum Discussion
Color Rows Based on Empty Cells
jfowles You may use Conditional Formatting for this, as demonstrated in the picture below (taken on a Mac, but similar on for PC).
Attached an example as well.
Riny_van_Eekelen Thank you so much!!! I've used your suggestion and it works! But I want to tweak it a little and I'm not sure how.
I highlighted a massive section going all the way down to rows that don't have a client in them so I don't have to keep editing this rule every time I add a new client. But now all the blank rows that don't have clients obviously don't have Dispositions. So, all of those client-less rows are yellow.
I'd like to do a formula to keep the current one in existence, but then to say if there's no client name in Column A, then there'd be no formatting regardless of the Disposition Column.
I've tried and tried and can't seem to figure it out
As a comment, another way is to place No Format rule on first position with Stop If True flag
