Conditional format every Friday for the whole year

**dilipandey** · 01-10-2012, 02:30 PM

Hi Sem,

See the attached file where I have given the logic for conditional formatting as per your need. Thanks.

Regards,
DILIPandey

<click on below 'star' if this helps>

**sem** · 01-10-2012, 02:52 PM

Good evening DiliPandey,
Thanks for your help,would you kindly give me the formula so i can manage to do it?
All the best
Sem

**bryanbak3** · 01-10-2012, 03:27 PM

Hi sem,
if you open dilipandey's attached workbook and enable editing then click on conditional formatting under home tab then go to manage rules you will see the formula there.