Conditional Formatting of cells between days of week (Sun to Mon Only)

[Manexcel]

In col A I have a list of dates for any given month. In col B I have the days of the week that correspond to the date in Col A. In col C to F there is other data.

My challenge is that I wish to format the cells with a line between each Sunday and Monday of each week in the month.

Example data is:

ColA ColB
1 Mon
2 Tues
3 Wed
4 Thur
5 Fri
6 Sat
7 Sun
8 Mon

to

31

So in the above example I wish to insert a line between days 7 and 8 and for the other Sundays and Mondays in the month

Can you please advise how to approach.

Many thanks as always

 

[Special-K99]

Select the entire range

Conditional Formatting
New Rule
Use a formula to determine...

=($B1="Sun")

Format using the border tab and add a line at the bottom
Use Format painter (paintbrush icon) to copy to other cells

 

[Manexcel]

Your solution works just great. Thank you so much. Much appreciated.