Macro - Changed text colour to white

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.
 
D

Debra Dalgleish

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
 
Top