Is there a way to use a formula as a cell format?
AFAIK, conditional formatting allows only static format applied based on some condition. I want the format itself to be dynamic. For example, I want to set the color of a cell to be its content (if the cell value is "red" then use red as the color), without setting a conditional formatting rule per each color.
I know that this can be done with a macro, but I don't want to run a macro after each cell change.