Format Cells with Empty Cell

%3CLINGO-SUB%20id%3D%22lingo-sub-3245234%22%20slang%3D%22en-US%22%3EFormat%20Cells%20with%20Empty%20Cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3245234%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Everyone%2C%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20would%20like%20to%20configure%20the%20format%20cell%20(as%20custom)%20so%20that%20when%20a%20cell%20is%20empty%20or%20blank%2C%20information%20based%20on%20customization%20comes%3A%3C%2FP%3E%3CP%3E%3CSTRONG%3E%5BRed%5D%5B%3D0%5D%22%3F%22%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22naesio_maia_1-1646313257962.png%22%20style%3D%22width%3A%20316px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F352768i2312198A0D5CCE2A%2Fimage-dimensions%2F316x313%3Fv%3Dv2%22%20width%3D%22316%22%20height%3D%22313%22%20role%3D%22button%22%20title%3D%22naesio_maia_1-1646313257962.png%22%20alt%3D%22naesio_maia_1-1646313257962.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EIt%20seems%20to%20be%20something%20simple%2C%20but%20I%20don't%20have%20much%20knowledge%20when%20it%20comes%20to%20custom%20Format%20Cells.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3245234%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20on%20mobile%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3245424%22%20slang%3D%22en-US%22%3ERe%3A%20Format%20Cells%20with%20Empty%20Cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3245424%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1094720%22%20target%3D%22_blank%22%3E%40naesio_maia%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EAfraid%20that%20doesn't%20work%2C%20if%20only%20VBA%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hi Everyone, 

 

I would like to configure the format cell (as custom) so that when a cell is empty or blank, information based on customization comes:

[Red][=0]"?"

 

naesio_maia_1-1646313257962.png

It seems to be something simple, but I don't have much knowledge when it comes to custom Format Cells.

1 Reply

@naesio_maia 

Afraid that doesn't work, if only VBA