Excel - Change cell format based on another cell format

[Roni Gzanda]

Is there any way to change a cell format, based on another cell FORMAT (not value).

For example - a color is added to one cell will change the color of another cell (or font, etc).

[#2]

You can probably do it with VBA, but I cant think of a way to do it via normal conditional formatting.

Is there a reason you can't use the values?

[#3]

Thanks, Philip for your prompt response.

To be more precise, I want to copy both the value, and the format.

VBA is not really an option in this case.

I will take this from here.

Thanks,

Roni

[#4]

@Philip West 

Do you have any suggestions for how this might be done using VBA. I have a small bit of programming experience, from more than 20 years ago, but thought it would be nice to at least have a starting point.

I have several cells that are copied across a schedule (for example, a class that meets Mon, Wed, and Fri) and I would like to copies to be italicized when I format Monday to italics.