I want to use Conditional Formatting to change a given cell’s format when the formatting of another cell is a certain format, e.g. if A1 is formatted as ‘Good’ (an inherent format in Calc) then B1 automatically changes to match, if A1 = ‘Bad’ then B1 is also ‘bad’.
How can I achieve this?
Do not try to use the formatting properties of a cell for some input values of another formulas or functions.
Use the data located inside the cell for that purpose.
You can format more than one cell based on one cell content by the Conditional Format feature. Just use the Formula option instead of the Content in the actual Condition.
Could this help, unfortunately only in German:
I did end up opting to use values instead, using the formula option you suggested.
Was just curious if there was a way at all, but there’s no way to refer to a cell’s format in the formula as far as I’m aware; formulae and formatting appear to function independently of one another.
Thanks for the input!
There is a limited access to some_cells Numberformat via
=CELL("Format"; some_cell)
see LO-help for CELL. … but I would not recommend to use this in another Conditional Format!