I am setting up a spreadsheet for the year and want to use it year over year. I have the cell set up with the date (1/1/2011) with a format of d so that it displays the date as Sat, 1/2/2011 - Sun, etc. Since I want to use this year after year with minimal work and I want to highlight the cells that are equal to Sat and Sun, how would I set up that formula. I tried the basic =A1="Sat" and without quotes but it just returns #NAME. I know working with dates in formulas is different but can't figure out what I need to use.
Well for a quick reply, since the whole date as a string starts with Sat try using =Left(A1,3)= "Sat" instead of just "Sat". Not sure if you can do that, but that would work in a cell
I am still not getting this to work for the shading the cells under that column. I also want to highlight the cells below based on that cell and be able to copy the formula to adjacent columns.
I am just assuming here but if your calendar is just cells with dates in them in a rectangular fashion. Highlight the whole calendar and type in that formula, it changes the cell value in the formula for each cell that it applies to automatically. Then it should shade all saturdays and sundays in the range you choose for conditional formatting.
Edit: Hehe...no worries Glad its working for you
Status
Not open for further replies.
You have insufficient privileges to reply here.
Related Threads
?
?
?
?
?
Tech Support Guy
9.9M posts
859.7K members
Since 1998
A forum community dedicated to tech experts and enthusiasts. Come join the discussion about articles, computer security, Mac, Microsoft, Linux, hardware, networking, gaming, reviews, accessories, and more!