Formatting a cell with a value based on another Cells Colour

[LittleJon]

Could someone advise how to format a cell with conditional formatting based on another Cells colour?

Or could someone point me in the right direction for learning this as a macro?

Thanks

 

[bobsan42]

Do you want to have the same color or only check what is the color and then use any conditional format you like?

 

[bobsan42]

check this post as well and think it though: https://www.mrexcel.com/forum/excel-questions/1090644-weird-udf-problem.html

 

[LittleJon]

Do you want to have the same color or only check what is the color and then use any conditional format you like?

I would like the same colour if possible.
I’ll check that other response ASAP.
Thanks

 

[bobsan42]

If the other cell is CF - make the target cell respond to the same format conditions.
If it is not: too many things to consider to even start explaining. you can maybe get a condition evaluate to TRUE, but the Format for this conditions is already defined - and you have to change it. But then NO event is triggered upon coloring the other cell to tell you that you have to do so. All in all it's easier to just press a button to transfer the format from one cell to the other.
Or you have to find a suitable cell value to base your conditional formatting on.

IMHO you should reconsider the idea to use CF in this way - there probably easier ways.