Format one cell with specific font & size etc

[ipbr21054]

Morning,

I have a cell of which is B13
This cell i would like to have it at a specific font size,font type etc.
This cell works on two different option.

I can select from a drop down list in the cell.
OR
I manually enter a value in the cell then pressing a button.

Either way the text is the incorrect font & size etc for what i need it to be.
Can you advise how i sort this please.

 

[Muhammad_Usman]

You can use conditionally formatting for this purpose.

 

[ipbr21054]

Do i need to add a code into the CF page if so please can you advise

 

[ipbr21054]

Hi,
I have done the following but the Font.Bold line of code cancels out the Alignment below it & as a result the text in that cell is shown to the left.
Can you advise why or the correct way to write it.

Thanks

Private Sub Worksheet_Activate()    Range("A13").Select
    ActiveWindow.ScrollRow = 14
    Range("B13").Interior.ColorIndex = 6
    Range("B13").Font.Size = 18
    Range("B13").Font.Bold = True
    Range("B13").Name = "Calibri"
    Range("B13").HorizontalAlignment = xlGeneral
    Range("B13").VerticalAlignment = xlCenter
End Sub