Dear Admin/Mod/Experts,
Auto Hilighting Day & Date For Sunday
i tried but no use............pls guide me.
Regards
SUn
Dear Admin/Mod/Experts,
Auto Hilighting Day & Date For Sunday
i tried but no use............pls guide me.
Regards
SUn
Last edited by Dr.SUN; 02-11-2010 at 10:03 AM.
Select entire range A6:AE7
then go to Home tab >> Conditional Formatting >> New Rule
Select use a formula to determine which cells to format
enter formula:
=WEEKDAY(A$6)=1
click Format and choose from the Fill menu.
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Dear NBVC,
Wowwwwwwwwwwwwwwwwwwwwww its work well
cheers
Dr.Sun
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks