how to change to other format ? vumian <vumian.2csunh_1156011607.465[ at ]excelforum-nospam.com> 19.08.2006 18:16:56 hi everyone, hi, if i have a range from A1 to A31, which per date in per cell during 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 advance -- vumian ------------------------------------------------------------------------ vumian's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=36494 View this thread: http://www.excelforum.com/showthread.php?threadid=573437

Re: how to change to other format ? vumian <vumian.2ctcpj_1156035010.1648[ at ]excelforum-nospam.com> 20.08.2006 00:46:30 hi, anyone can help me please ? thanks in advance -- vumian ------------------------------------------------------------------------ vumian's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=36494 View this thread: http://www.excelforum.com/showthread.php?threadid=573437

Re: how to change to other format ? Gord Dibben <gorddibbATshawDOTca> 20.08.2006 15:58:54 You cannot re-format in that manner with CF. Changing colors, fonts or borders are your only options. Gord Dibben MS Excel MVP On Sat, 19 Aug 2006 20:46:30 -0400, vumian <vumian.2ctcpj_1156035010.1648[ at ]excelforum-nospam.com> wrote: [Quoted Text] > >hi, > >anyone can help me please ? > >thanks in advance