Aug 15 2018 02:35 AM - edited Aug 15 2018 02:35 AM
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).
Aug 15 2018 03:42 AM
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?
Aug 15 2018 05:29 AM
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
May 24 2019 09:16 AM
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.