I’ve got a Calc document that I want to set up so that when someone’s name is filled in one cell, other adjacent cells automatically fill up with their details (e.g. their age, ethnicity etc.).
Am not sure if conditional formatting is suitable for this- if so I can’t seem to work out how to get it to perform this function.
I know how to get Libreoffice to do things like change the background colour of the cells when the individual’s name is entered into the other cell, but can’t get it to autofill text using Conditional Formatting.