I have a list of actions described in a table. Column A depicts the action number #1, #2, #3 etc.
Column G depicts dependencies on other actions. E.g., Action #7 is depended on #1, hence, G10=A4. Since some actions are depended on multiple other actions I have used CONCAT in column G (e.g., G14=CONCAT(A5;", ";A7;", ";A8).
Column F depicts the status of the action (Not started, In progress, Done).
I want to use conditional formatting to fill the entire row for an action if every dependant action mentioned in column G has it's F value = Done.
I have tried the =AND formula in conditional formatting, but I cannot make it work.