I Need Help with Microsoft Excel Conditional Formatting Logic

Hello,

I need support from a Microsoft Excel expert regarding making rows bold for a specific time (such as every 2 days, 5 days or 50 days)

This will help our editors to know when to publish an article for a category

Please see the video here, you can understand more

Video - https://drive.google.com/file/d/1fQRWpzcOaUz7_8mvlTOj2oR6mrZo2-NQ/view?usp=sharing

I need you to provide me with logic for these conditions for Excel to make rows bold for every 2 days, 5 days, or 50 days

To make you understand properly

For the category that will get an article after 7 days interval, it will happen this way


For 7 days cycle

Day 0 (start date) - text will be bold on start day (2026,4,8)

Day 1 - text is normal

Day 2 - text is normal

Day 3 - text is normal

Day 4 - text is normal

Day 5 - text is normal

Day 6 - text is normal

Day 0 (7th day) - text is bold again (for the 7th day the reminder will be 0 again)


For 3 days cycle

Day 0 (start date) - text will be bold on start day (2026,4,8)

Day 1 - text is normal

Day 2 - text is normal

Day 0 (3rd day) - text is bold again (for the 3rd day the reminder will be 0 again)


This loop will continue

Let me know if you get this

-Ahmed