Conditional formatting based on multiple cells

Occasional Visitor



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. 

1 Reply
Can you send the sample data or file, so that I can give solution.