Forum Discussion

jfowles's avatar
jfowles
Copper Contributor
Sep 29, 2020

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
Riny_van_Eekelen's avatar
Riny_van_Eekelen
Platinum Contributor
Sep 30, 2020

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.

  • jfowles's avatar
    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

Resources