What you want is conditional formatting.

Select A1:A31
Goto FormatConditional 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
OK
OK


--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"vumian" wrote in
message ...

hi everyone,

hi, if i have a range from A1 to A31, which per date in per cell during
month

how to check from fisrt to end of month what is sunday (or other) and
fill color it ?

thanks in advance


--
vumian
------------------------------------------------------------------------
vumian's Profile:
http://www.excelforum.com/member.php...o&userid=36494
View this thread: http://www.excelforum.com/showthread...hreadid=572676