LinkBack URL
About LinkBacks
Good evening,
I'll be very greatful if you could help me to CF evry friday with date for the whole year?
see attachment.
thanks and regards
Sem.
Good evening,
I'll be very greatful if you could help me to CF evry friday with date for the whole year?
see attachment.
thanks and regards
Sem.
Last edited by sem; 01-12-2012 at 12:44 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>
DILIPandey, Excel rMVP
+919810929744 (India), +971528225509 (Dubai), dilipandey@gmail.com
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
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.
Hi Sem,
Fornula is already there. Open the conditional formatting window and select / Edit the formatting to view the formulas used. Hope this helps.
Regards,
DILIPandey
<click on below star if this helps>
Hi Sem,
Fornula is already there. Open the conditional formatting window and select / Edit the formatting to view the formulas used. Hope this helps.
Regards,
DILIPandey
<click on below star if this helps>
Note that the two conditions could be combined with OR:
=OR(TEXT($A2,"DDD") = "Fri",$A2="Friday")
That's just taking Dilipandey's solution and combining the formulae.
Regards, TMS
Last edited by TMS; 01-10-2012 at 04:30 PM.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Thanks Bryan. .
Nicely explained.
Regards,
DILIPandey
<click on below star if this helps>
good evening,Bryankak,TMShucks and Dilipandey,
thanks you very very much for your help and explanation, now i can manage to do it .
this tread is solved.
Have a very good night.
Sem
You're welcome. Thanks for the rep.
Based on your sample just TEXT function will work, like
=TEXT($A2,"dddd")="Friday"
Regards,
Haseeb Avarakkan
__________________________________
"Feedback is the breakfast of champions"
You are welcome sem..
Cheers
Regards,
DILIPandey
<click on below 'star' if this helps>
Thank you Haseeb,
You're formula also works nicely,
very much appreciated
Sem
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks