Hi there,
this problem occurs pretty often to me too and I guess sooner or later for several users too!
Right now I have a table with 30 rows of parameters and 10 columns of test objects. And I want to evaluate every test object in relation to the parameters with marks from 1 best till 6 worst. For every mark there shall be another color displayed in the cell.
I litteraly have to enter the conditional formats a 60 times manually !!!
THIS CAN’T BE THE SOLUTION !!
You Cody Guys always think along and try to make the best experience for the user so please find a solution for this issue too!
For Example give the user the option to save a conditional format as a preset and allow to use it not only for rows but for columns or other tables!
This was already suggested here: Copy Conditional Formatting Between Unrelated Tables / Conditional Formatting “Presets”
Kind regards