Macro - Changed text colour to white

  • Thread starter Thread starter Salza
  • Start date Start date
S

Salza

Hello all,
I want to set a macro to a cell (or range of cells) where all text colour
will be changed to 'white' if all the letters (text) in this cell is
CAPITALIZED.
Any suggestion? Thanks.
 
You can do this with conditional formatting:

1. Select the cell(s)
2. Choose Format>Conditional Formatting
3. From the first dropdown, choose Formula Is
4. In the formula box, type a formula that refers to the active cell
in the selected range, e.g.: =EXACT(A2,UPPER(A2))
5. Click the Format button, and on the Font tab choose white
as the font colour
6. Click OK, click OK
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Changing coloue cell en text colour by clicking cell 3
Conditional formatting in Excel 2010 2
Remove colour change 4
Simple colour dropdown 3
I need to count and / or sum cells with specific text colours. Hel 3
Excel Conditional Formatting Removal 7
Changing the backcolor of a cell when data is added 1
text and background colour 2

Back
Top