Does anyone know how to change the DATA VALIDATION box color from yello
to orange or red (to make the message appear more precautionary)? An
help is appreciated. Thanks

--
gtto
-----------------------------------------------------------------------
gtton's Profile: http://www.excelforum.com/member.php...fo&userid=2472
View this thread: http://www.excelforum.com/showthread.php?threadid=38693

This worked for me using Excel 2000

I put this code in the worksheet module
DataValidation cell is B13
set your own conditions...

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$B$13" Then
If Target < 12 Then
Target.Interior.ColorIndex = 44
ElseIf Target = 12 Then
Target.Interior.ColorIndex = xlNone
End If
End If
End Sub


--
steveB

Remove "AYN" from email to respond
"gtton" wrote in
message ...

Does anyone know how to change the DATA VALIDATION box color from yellow
to orange or red (to make the message appear more precautionary)? Any
help is appreciated. Thanks.


--
gtton
------------------------------------------------------------------------
gtton's Profile:
http://www.excelforum.com/member.php...o&userid=24721
View this thread: http://www.excelforum.com/showthread...hreadid=386933

The data validation input message appearance is controlled by your
Tooltip settings. To change the font type or colour, or background colour:

(Instructions for Windows XP)
Note: this will also affect ToolTips and Comments

Right-click on the desktop, and choose Properties
On the Appearance tab, click Advanced.
From the Item dropdown, choose Tooltip
Choose a font, font colour, and/or background colour
Click OK, click OK

As an alternative, if you can use programming, you could use a textbox
to display the input message. There's an example he

http://www.contextures.com/excelfiles.html

Under Data Validation, look for 'Input Message in Textbox'


gtton wrote:
Does anyone know how to change the DATA VALIDATION box color from yellow
to orange or red (to make the message appear more precautionary)? Any
help is appreciated. Thanks.




--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html