Color Rows Based on Empty Cells

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" colum...

excel

Formulas and Functions

jfowles

Copper Contributor

Oct 11, 2020

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