Sep 29 2020 03:49 PM
I have a list of clients going down Column A, with information about each client going across the rows to multiple columns. When services are completed for a client, I fill in my "Disposition" column on that client's row. If services are not complete, that client's "Disposition" cell block remains empty (or blank).
I'd like to have each client whose services are not complete, therefore, whose "Disposition" cell block is empty, to have their entire row highlighted Yellow. Then, once I fill in that block, I want the Yellow highlight to go away. That way I can always easily see which client in my long list's case is still pending.
Any ideas?
Sep 29 2020 10:31 PM
@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.
Oct 11 2020 12:18 PM
@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
Oct 11 2020 10:16 PM
Oct 12 2020 09:22 AM - edited Oct 12 2020 09:23 AM
As a comment, another way is to place No Format rule on first position with Stop If True flag