Day & date shading

  • Thread starter Thread starter michaelberrier
  • Start date Start date
M

michaelberrier

Column A has dates; Column B has days of the week which come from
Column A. In other words, in B1 it says "=A1" and is formatted to
give me the day instead of the date.

How can I use conditional formatting to shade B1 gray based on the
DAY, not the date, that shows up if it is a weekend?

Thanks,
 
Format/ Conditional Formatting/ Formula is/ =WEEKDAY(B1,2)>=6
and set your grey shading.
 
A couple of ways and here's one.

Select your cell

format|conditional formatting|cell value is| equal to

="Sat"

set your colour

and add a second condition for Sun

Mike
 
Have you tried that idea, Mike?

It would work if the cell contents were text values of "Sat" and "Sun", but
they're not. They are dates formatted as day.
If instead of =A1 formatted as day, B1 had contained the formula
=TEXT(A1,"ddd"), then your idea would have worked, but that isn't what the
OP has.

Hence the suggestion of the "Formula is" option using WEEKDAY.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Comparison of columns using Conditional Formatting 3
Conditional Formatting by percent range 2
Weekend dates conditional format 3
Formatting rows 10
Automatically Enter Formula in a Cell After Entering Data in Another Cell 0
Conditional Formatting Help 3
Conditional format Column based on Week Date 2
Timesheet help 3

Back
Top