Showing message

[Maya9]

Hi,

I am using Conditional Formatting function in the Excel which will show value in the cell in red color if it is for example higher then the cell that is reffering in the Condition Formatting configuration window.

However, now I would like to add txt message saying for example "Value too high", so wondering and presuming that would be possible with the VB coding.

Any ideas and help would be appreciated
Thanks in advance
Maya

[teylyn]

Hello,

where would you want this message to appear? You can have text appear in the next cell. Use the same condition as in your conditional format.

For example, if your conditional format is using the formula

=A1>B1

then you could use something like this in the next cell

=if(A1>B1,"Value too high","")

cheers

[Maya9]

Thanks teylyn

I have tried that, however nothing happens. I have used Conditional Formatting from the Tools menu, added formula as suggested above but don't see message.

I am probably missing something (obvious!)..will try to find out what.
Thanks again for help

[teylyn]

Have you put the formula into a cell as I suggested?

What is your conditional formatting formula? Are you using a condition with Formula Is or with Cell Value Is?

Can you post a small example in an Excel file?

[Maya9]

Thanks again for quick reply. Yes, I have added formula in the cell, please see the simplified version of what I am trying to do.
Cells where value and alarm value are, are actually derived automatically by connecting to one of databases, but I have just enetered it manually as example. And cell B3 is where Conditional Formatting is applied.

[Maya9]

Sorry, ignore my last post, of course, as you have suggested, if I type formula directly to cell, it works fine, I don't really need coloring, so am happy with that.
Thanks again a lot for your help
Maya