Home

Excel - Change cell format based on another cell format

%3CLINGO-SUB%20id%3D%22lingo-sub-228826%22%20slang%3D%22en-US%22%3EExcel%20-%20Change%20cell%20format%20based%20on%20another%20cell%20format%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-228826%22%20slang%3D%22en-US%22%3E%3CP%3EIs%20there%20any%20way%20to%20change%20a%20cell%20format%2C%20based%20on%20another%20cell%20FORMAT%20(not%20value).%3C%2FP%3E%3CP%3EFor%20example%20-%20a%20color%20is%20added%20to%20one%20cell%20will%20change%20the%20color%20of%20another%20cell%20(or%20font%2C%20etc).%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-228826%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-644424%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20-%20Change%20cell%20format%20based%20on%20another%20cell%20format%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-644424%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F170772%22%20target%3D%22_blank%22%3E%40Philip%20West%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDo%20you%20have%20any%20suggestions%20for%20how%20this%20might%20be%20done%20using%20VBA.%20I%20have%20a%20small%20bit%20of%20programming%20experience%2C%20from%20more%20than%2020%20years%20ago%2C%20but%20thought%20it%20would%20be%20nice%20to%20at%20least%20have%20a%20starting%20point.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20several%20cells%20that%20are%20copied%20across%20a%20schedule%20(for%20example%2C%20a%20class%20that%20meets%20Mon%2C%20Wed%2C%20and%20Fri)%20and%20I%20would%20like%20to%20copies%20to%20be%20italicized%20when%20I%20format%20Monday%20to%20italics.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-228890%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20-%20Change%20cell%20format%20based%20on%20another%20cell%20format%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-228890%22%20slang%3D%22en-US%22%3E%3CP%3EThanks%2C%20Philip%20for%20your%20prompt%20response.%3C%2FP%3E%3CP%3ETo%20be%20more%20precise%2C%20I%20want%20to%20copy%20both%20the%20value%2C%20and%20the%20format.%3C%2FP%3E%3CP%3EVBA%20is%20not%20really%20an%20option%20in%20this%20case.%3C%2FP%3E%3CP%3EI%20will%20take%20this%20from%20here.%3C%2FP%3E%3CP%3EThanks%2C%3C%2FP%3E%3CP%3ERoni%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-228846%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20-%20Change%20cell%20format%20based%20on%20another%20cell%20format%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-228846%22%20slang%3D%22en-US%22%3E%3CP%3EYou%20can%20probably%20do%20it%20with%20VBA%2C%20but%20I%20cant%20think%20of%20a%20way%20to%20do%20it%20via%20normal%20conditional%20formatting.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20there%20a%20reason%20you%20can't%20use%20the%20values%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E
Roni Gzanda
New Contributor

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

3 Replies

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?

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

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