how to change to other format ?

[vumian]

hi everyone,

hi, if i have a range from A1 to A31, which per date in per cell durin
month
and here is a way that i fill the color sunday

Select A1:A31
Goto Format>Conditional Formatting
Change Condition 1 to Formula Is
Add a formula of =WEEKDAY(A1)=1
Click the Format button
Select the Pattern Tab
Select an appropriate highlighting colour


if per date is sunday, i wanna change the format of it to "sunday"

How to do it ?

thanks in advanc

 

[vumian]

hi,

anyone can help me please ?

thanks in advanc

 

[Gord Dibben]

You cannot re-format in that manner with CF.

Changing colors, fonts or borders are your only options.


Gord Dibben MS Excel MVP