Forum Discussion
Roni Gzanda
Aug 15, 2018Copper Contributor
Excel - Change cell format based on another cell format
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).
Philip West
Aug 15, 2018Iron Contributor
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?
- mr_bennettMay 24, 2019Copper Contributor
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.
- Roni GzandaAug 15, 2018Copper Contributor
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