Home

Using Conditional Formatting rule to add text "NO DATA" in Blank or Empty Cells

%3CLINGO-SUB%20id%3D%22lingo-sub-868587%22%20slang%3D%22en-US%22%3EUsing%20Conditional%20Formatting%20rule%20to%20add%20text%20%22NO%20DATA%22%20in%20Blank%20or%20Empty%20Cells%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-868587%22%20slang%3D%22en-US%22%3E%3CP%3EThank%20you%20for%20taking%20the%20time%20to%20read%20my%20Post%2C%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20trying%20for%20a%20while%20to%20make%20a%20conditional%20formatting%20rule%20to%20add%20text%20%22NO%20DATA%22%20and%20make%20the%20theme%20red%20with%20bold%20white%20writing%2C%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ehow%20can%20I%20add%20to%20the%20blank%20or%20empty%20cells%20the%20text%20%22NO%20DATA%22%20with%20theme%20color%20changing%20to%20red%20in%20the%20conditional%20formatting%3F%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F132883i20CA2600383C7EFB%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22NO%20DATA%20Conditional%20Formatting.jpg%22%20title%3D%22NO%20DATA%20Conditional%20Formatting.jpg%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EAppreciate%20it.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-868587%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-887551%22%20slang%3D%22en-US%22%3ERe%3A%20Using%20Conditional%20Formatting%20rule%20to%20add%20text%20%22NO%20DATA%22%20in%20Blank%20or%20Empty%20Cells%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-887551%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F412895%22%20target%3D%22_blank%22%3E%40Hisham1990%3C%2FA%3E%26nbsp%3BUnfortuntately%2C%20Conditional%20Formatting%20can't%20return%20text.%20It%20can%20only%20change%20the%20format.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Hisham1990
Occasional Visitor

Thank you for taking the time to read my Post, 

 

I'm trying for a while to make a conditional formatting rule to add text "NO DATA" and make the theme red with bold white writing, 

 

how can I add to the blank or empty cells the text "NO DATA" with theme color changing to red in the conditional formatting? 

NO DATA Conditional Formatting.jpg

Appreciate it. 

1 Reply

@Hisham1990 Unfortuntately, Conditional Formatting can't return text. It can only change the format.

Related Conversations
Conditional Formatting - Consider Only Value as Lowest Value
Ben Smith in Excel on
2 Replies
Dont see any Contact in Teams
nicb in Microsoft Teams on
2 Replies
Problems with formating text within a cell.
Maciej Fox in Excel on
10 Replies
Superscript and Subscript ribbon buttons
Lenoire77 in Excel on
3 Replies
Pulling data from one tab to another
krysphares in Excel on
6 Replies