Formatting a cell to % or General based on the data in other cell

[SJC27x5]

Hi,

I have drop down box where I need to select certain paraments.

Marks
% to Total marks

Ex: the result will fetch in cell B10, I need make the cell formatting of B10 to % if the selection in dropdown is % to Total marks, and the formatting of B10 to General for selection as marks.

I was searching for this in google, but didn't find an answer.

Thanks for your support.

 

[Joe4]

So you want to format cell B10 based on the selection of a drop-down box?

Assuming that:
- the drop-down box is a Data Validation box
- the drop-down box is in cell A1

Then right-click on the sheet tab name at the bottom of the screen, select "View Code", and paste this code in the VB Editor window that pops up:

Private Sub Worksheet_Change(ByVal Target As Range)

'   Change address to cell of drop-down box
    If Target.Address = Range("A1").Address Then
        Select Case Target.Value
            Case "Marks"
                Range("B10").NumberFormat = "General"
            Case "% to Total marks"
                Range("B10").NumberFormat = "0.00%"
        End Select
    End If

End Sub

This will automatically run when the drop-down box value is changed.

Simply change the "A1" address in the code to match whatever range the drop-down box is located in.