Conditional formating based on another range that is bold or italic

[Kamesh63]

Hi,

I have an unformated range of cells in column $A$ that have matching values in a named list, which are formatted either bold, italic, etc. I want to apply the same format to my unformated range in $A$ using conditional formating. I.e. if a cell in $A$ has a matching value in named list, it should take the same format of the match. How can I do this using conditional format or otherwise.


Thanks for the help.

 

[Luke M]

You can't do that.

To bring over the format settings, you could use a macro that would loop through the cells and copy the formatting over, but the format would be a hard format, not conditional. Is this an option (asking before we take the time to write such a thing)?

 

[Kamesh63]

Since this is not available through conditional formating the alternative option should be ok. Let me explore writing a macro. Thanks Luke for the advice!