I have two rows and five columns. I need to apply conditional formatting to all the values in first row based on the corresponding values in second row. All the values are unique. Instead of applying the conditional formatting five times is there a way to apply conditional formatting just in one step?
Solved by X. Y. in 30 mins