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
 
Back
Top