Hey there,
I use librecalc for creating timesheets and find it tedious to manually set the conditional formatting rules for each and evrery “time code” that gets added, as these keep getting frequently changed.
Is it possible that I could set up a spreadsheet such that either:
-
The cell’s background color is “randomly” selected based on the value of the cell. E.g. it could be some sort of hashing function that translates to a color hex code. Thus if I type “automation” into two different cells, I may not know what background color it will assign, but both will get the same background color because they both have the value of “automation”.
-
I could set the hex code for the color to use for the values in a lookup table
I already have the list of allowed task names for doing the data validity check to prevent invalid values being entered so it would make sense to turn this into a lookup table with the color beside the task name.
At the end of the day, I would like it to color code the tasks so I can easily spot repeats of the same task name without having to manually create a conditional rule for each and every possible value for Task