Forum Discussion

Jonathan950's avatar
Jonathan950
Copper Contributor
Aug 18, 2022

Conditional Formatting

Is there any posibility to insert the conditional formatting to a cell depending on the color from another cell?

 

For example:

158262022144520221446

Cell 15826 have to be as the same color as cell with 20221446, that is red

Is it possible with a function or formula?

 

Thanks for your answers.

  • JKPieterse's avatar
    JKPieterse
    Silver Contributor
    No, conditional formatting cannot read formatting of cells. It may be pulled off with some VBA, but that (in my experience) is slow and may cause unexpected behavior when used in CF. Add a column with values which determine whether or not that red cell needed to become red.

Resources