EXCEL Conditional Formatting

[Daniel22]

I have a chart with days across row 1 and dates across row 2.  Down column A I have names.  I would like to format the columns so TODAY is yellow, all future days are white (unformatted), passed days are light grey and weekend days ("Sat" and "Sun") are dark grey.  I have formatted the columns with formulas such as "=B2=TODAY()" for yellow and only the top cell turns yellow, and the same for all of the other colors.  What am I doing wrong?

Thanks, Daniel

[soybean]

You did not mention Conditional Formatting.  Did you try it?

[Daniel22]

I have tried Conditional Formatting, and though I put the range in as the whole coulumn in the chart it results in only "coloring" the top cel in the column.

[soybean]

Please describe the layout of your Excel file.  Does column B contain a date entered by you?  What are the other columns?

[Daniel22]

The chart is an attendance sheet that has days on the top row, date on the second row and names down the first column.  Attendance will be entered by an individual with a disabilility, so I was trying to cue them with the curren day by highlightling that column in yellow, greying out the passed days, dark-greying weekends (because there will be no attendance on those days), and future days will be white.

[soybean]

Can you save an Excel file with some fictitious names in it and post it here.  To do that, you can attach the Excel file to your post by clicking Attachments and other options below your forum post composition panel and then browse to the file on your computer and select it for attachment.

[oldun]

Try this:

Select all the date cells, not just a single column, then enter the following 3 formulas for the conditional format:

Code: [Select]

=OR(WEEKDAY(B2)=1,WEEKDAY(B2)=7)                   Format as Dark Grey
=AND(B2<TODAY(),WEEKDAY(B2)<>1,WEEKDAY(B2)<>7)     Format as Light Grey
=AND(B2=TODAY(),WEEKDAY(B2)<>1,WEEKDAY(B2)<>7)     Format as Yellow


[Daniel22]

PROBLEM SOLVED