Hi,
I have a column whose data type is date. There is a date for each day.
I'd like to set the cell color for weekends (Sat & Sun). Is there an easy way to do this automatically?
Thanks,
zoli
Hi,
I have a column whose data type is date. There is a date for each day.
I'd like to set the cell color for weekends (Sat & Sun). Is there an easy way to do this automatically?
Thanks,
zoli
Hi,
You can use Conditional Formatting to produce what you want, take a look here
http://www.bettersolutions.com/excel...N721914332.htm
oldchippy
-------------
Blessed are those who can give without remembering and take without forgetting
If you are happy with the help you have received, please click the <--- STAR icon on the left - Thanks.
Click here >>> Top Excel links for beginners to Experts
Forum Rules >>>Please don't forget to read these
That's great!
Many thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks