condtional formating to displat text message

**hai_krk** · 04-07-2010, 10:22 AM

Is it possible to display a text message based on condiiton format

I used conditional formating to shade the cell in red when the cell value is >5, if it exceeds then it should display a error message. Is it possible n conditional formating or do i need to write macros

**NBVC** · 04-07-2010, 10:30 AM

You can use Data Validation to disallow user to enter value greater than 5 and give an appropriate error...

Go to Data|Validation

Select Whole Number (or Decimal) from Allow menu...

Select Less Than

Enter 5

Click Ok.

You can also edit the Error message... through the Error Alert Tab in the Data Validation.

Is that what you wanted... or do you want to display an error code in another cell instead?

**hai_krk** · 04-08-2010, 02:47 AM

hi,

thanks.i will try this out. I need to know whether is it possible to display a message based on color.

**NBVC** · 04-08-2010, 08:06 AM

With Native Excel you cannot display a message based on colour.. but you can display a message (in another cell) based on the same condition that created that coloured cell...

e.g.

=IF(A1>5,"Error Alert","")

put in another cell, will give an "Error Alert" if A1 is greater than 5.

**jhren** · 09-28-2014, 03:42 AM

I realize this is an old thread, but I remembered that I managed once upon a time to display text as a conditional format. Couldn't remember how so I did a web search to no avail... but ran across this thread in the process.

Anyway, I finally managed to dig up the file in which I did it previously. Took me a while to figure out how I did it, even with the evidence right in front of me. Here's how...

When you apply formatting for the conditional format rule, go to the Number tab, select Custom under Category. Then in the Type box, enter your text message within quotation marks (and nothing else).

**jhren** · 09-28-2014, 04:23 AM

I just figured out a nuance to the preceding "trick" that I did not realize before...

If the cell is blank or non-numerical, the CF text does not appear, but all other formatting does. Is there a way "format" the Number format to make the text appear if the cell is blank or non-numerical?

**jhren** · 09-28-2014, 04:34 AM

I just figured out a nuance to the preceding "trick" that I did not realize before...

If the cell is blank or non-numerical, the CF text does not appear, but all other formatting does. Is there a way to "format" the Number format to make the text appear if the cell is blank or non-numerical?