Conditional Formatting

New Contributor

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.

1 Reply
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.