Forum Discussion
Jonathan950
Aug 18, 2022Copper Contributor
Conditional Formatting
Is there any posibility to insert the conditional formatting to a cell depending on the color from another cell?
For example:
15826 | 20221445 | 20221446 |
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.
- JKPieterseSilver ContributorNo, 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.