in a table, one request number has one row for each phase i.e start,1, 2,3,4 and lastly complete. I want to use if function to check if for a unique request no., "complete" phase exists. If yes, then format all rows with the same request no in green
Solved by Z. E. in 17 mins