Formula to change text format to BLOCK CAPITALS

[Georgeina]

I have created a spreadsheet to record names of guests invited to an
event, with a yes/no drop down list [column B] to record their response
to the invitation.

I want to create a formula which will convert their name [columns D &
E] to BLOCK CAPITALS if I record a 'yes' response. I don't know how to
make this happen, beyond knowing I have to write some kind of formula.
Please help!

 

[Paul]

I have created a spreadsheet to record names of guests invited to an
event, with a yes/no drop down list [column B] to record their response
to the invitation.

I want to create a formula which will convert their name [columns D &
E] to BLOCK CAPITALS if I record a 'yes' response. I don't know how to
make this happen, beyond knowing I have to write some kind of formula.
Please help!

Take a look at the UPPER function. For example:
=UPPER(A1)

 

[Don Guillett]

Homework or coincidence?
Sub makeupper()
For Each c In Range("a1:a10")
c.Value = UCase(c)
Next
End Sub

 

[Gord Dibben]

Georgina

Why block capitals?

If just to highlight the names with a Yes in Column B it would be easier to
highlight them as Bold Underlined or a nice color.

Select cells with guests in column D and Format>Conditional
Formatting>Formula is:

=B1="yes"

Format as you wish using examples above. OK your way out.

Select cells in Column E and repeat.

Gord Dibben XL2002