Forum Discussion

Roni Gzanda's avatar
Roni Gzanda
Copper Contributor
Aug 15, 2018

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).

excel

3 Replies

  • Philip West's avatar
    Philip West
    Iron Contributor
    Aug 15, 2018

    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_bennett's avatar
      mr_bennett
      Copper Contributor
      May 24, 2019

      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. 

    • Roni Gzanda's avatar
      Roni Gzanda
      Copper Contributor
      Aug 15, 2018

      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

Resources