I have an excel data in 10ten columns. Each column is defined with distinct conditional formatting respectively with Green, Red & Yellow colors. Now based on below mentioned rule i want 11th column to be color coded automatically.
Green - If all the columns are green
Yellow - If any one...