Making certain columns contain bold texts dynamically

[greenpower78]

Hello there, I am a new member in this forum (just joined now). I am in my Excel learning journey and I hope that I can make contributions to this forum soon i.e., hoping to be active.

Greetings aside, here is my problem. I wish to make a row of dates (not in columns which is usually the case) say up to 28 days which is exactly 4 weeks. The column containing 7th day of a week will be entirely in bold. Similarly, the 7th day of next week will also be bold and so on. Suppose I begin with 22nd of April to 19th of May as shown below:

So from the above figure the dates 4/28. 5/5, 5/12. 5/19 are in bold. What I am trying to do is, not make these specific dates bold, but whatever are contained in columns K, R, Y, AF bold. That is, if I delete the column containing the date 4/22 and shift all the cells to the left, this time 4/29 should be bold and not 4/28. I hope I made my problem clear. What is the solution?

 

[Habtest]

Welcome to the Board.

One way to go is by conditional format, making cells bold in every 7th column starting from column E

Test.xlsx
	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB
1
2
3
4	4/22	4/23	4/24	4/25	4/26	4/27	4/28	4/29	4/30	5/1	5/2	5/3	5/4	5/5	5/6	5/7	5/8	5/9	5/10	5/11	5/12	5/13	5/14	5/15
5	XXX	XXX	XXX	XXX	XXX	XXX	XXX	XXX	XXX	XXX	XXX	XXX	XXX	XXX	XXX	XXX	XXX	XXX	XXX	XXX	XXX	XXX	XXX	XXX
6	XXX	XXX	XXX	XXX	XXX	XXX	XXX	XXX	XXX	XXX	XXX	XXX	XXX	XXX	XXX	XXX	XXX	XXX	XXX	XXX	XXX	XXX	XXX	XXX
7	XXX	XXX	XXX	XXX	XXX	XXX	XXX	XXX	XXX	XXX	XXX	XXX	XXX	XXX	XXX	XXX	XXX	XXX	XXX	XXX	XXX	XXX	XXX	XXX
Sheet1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
E5:AB7	Expression	=MOD(COLUMNS($E:E),7)=0	text	NO

 

[greenpower78]

Solved my problem! Thank you!

 

[Habtest]

Glad it works, thanks for the feedback.