Excel - Change cell formatting based on contents of another cell 1

[maxxheight]

I have an Excel spreadsheet with a cell(A90) that offers the choice of choosing A, B, or C. If the user chooses A or B, then the number in cell P90 should be a percentage, but if the user chooses the C value for A90, then the format of cell P90 needs to be in Dollars. I tried using conditional formatting, but that only allows you to change colors and font.

Wondering if anyone has an idea on how to do this.

Thanks

Mark

 

[SkipVought]

Mark,

Can't be done with native worksheet functionality.

However, CAN be done with VBA code. Copy 'n' paste in the SHEET Object (right click the sheet tab)

Private Sub Worksheet_Change(ByVal Target As Range)
   Dim rng
   With Target
      Set rng = Application.Intersect(Target, Range("A:A"))
      If Not rng Is Nothing Then
         Select Case .Value
            Case "A", "B"
               Cells(.Row, "P").NumberFormat = "0%"
            Case "C"
               Cells(.Row, "P").Style = "Currency"
         End Select
      End If
   End With
End Sub

Skip,
[sub]
[red]Be advised:[/red] When transmitting sheet music...
If it ain't baroque, don't fax it! [/sub]

 

[maxxheight]

Thanks a million.

I will give it a shot today and see how it works out.

Have a great day.

Mark