Tech Support Guy banner
Status
Not open for further replies.

Solved: Excel 2007: conditional format when date displayed as format d

3K views 6 replies 2 participants last post by  chaostheory 
#1 ·
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.
 
#7 ·
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.
Top