How to popup and change color

**synoptic** · 08-19-2008, 03:45 AM

Hello,

I want to popup a text if data is wrong and want to change color in collumns same time.

I have an small example that shows text in cel if data is wrong buut it's not a real popup and it is not changing color of the wrong data.

I hope your the one that can help me out and help me with what I want. I have made my example in the add file.

Greetings

**royUK** · 08-19-2008, 04:39 AM

You can use Data Validation to control what is input into a cell, this feature also allows a popup warning. See:

http://www.excel-it.com/data_validation.htm

You can change a cell's formatting by using Conditional Formatting

http://www.excel-it.com/excel_condit...formatting.htm

**synoptic** · 08-19-2008, 03:26 PM

I checked but thats not what I was looking for. I hope you can help me out by telling how I can change the color of the text in the cels that have the wrong falue