May 30, 2011

Microsoft Excel 2010

Excel Options
1. Proofing > AutoCorrect Options > AutoCorrect
Correct TWo INitial CApitals = no

2. Advanced > Editing options
Enable AutoComplete for cell vales = no

Multiple choice in drop down menu
Option Explicit
Private Sub Worksheet_Change(ByVal Target As Range)
   Dim rngDV As Range
   Dim oldVal As String
   Dim newVal As String
   If Target.Count > 1 Then GoTo exitHandler
   On Error Resume Next
   Set rngDV = Cells.SpecialCells(xlCellTypeAllValidation)
   On Error GoTo exitHandler
   If rngDV Is Nothing Then GoTo exitHandler
   If Intersect(Target, rngDV) Is Nothing Then GoTo exitHandler
   Application.EnableEvents = False
   newVal = Target.Value
   Application.Undo
   oldVal = Target.Value
   Target.Value = newVal
   If oldVal = "" Then GoTo exitHandler
   If newVal = "" Then GoTo exitHandler
   Target.Value = oldVal & ", " & newVal
   exitHandler:
      Application.EnableEvents = True
End Sub

Conditional Formatting
New Rule > Use a formula to determine whice cells to format
Format > Font > Color > More Colors > Custom
Format > Fill > Background Color > More Colors > Custom

=$F1="complete"
RGB 0 97 0
RGB 198 239 206

=$F1="pending"
RGB 156 101 0
RGB 255 235 156

=$F1="reject"
RGB 156 0 6
RGB 255 199 206

Links

contextures.com/excelfiles.html
contextures.com/xlcondformat02.html
excelforum.com/excel-2007-help/741755-excel-2003-multiple-chooice-in-drop-down-menu-list.html

1 comment:

  1. Onspotsupport tech team are available 24/7 for repairs on computers, printers, laptops, desktops. Our tech team taken to new heights with our technician’s knowledge and support.

    ReplyDelete