Hello,
I'm trying to figure out a conditional formatting formula for: If the date in L4 is a Sunday, put "Sunday" in L5.
Thanks!
Hello,
I'm trying to figure out a conditional formatting formula for: If the date in L4 is a Sunday, put "Sunday" in L5.
Thanks!
Not CF but please try formula at L5
=text(L4,"dddd")
Hi,
Thanks for the quick reply. While that works in general, it does not work in my case as L5 is a drop-down box hence why I think CF is how I have to do it. I've attached a sanitized WB to work with. In this one, the CF I would need is If the date in J3 is a Sunday, put "Sunday" in E5.
Formula:Please Login or Register to view this content.
atul
If my answer (or that of other members) has helped you, please say "Thanks" by clicking the Add Reputation button at the foot of one of their posts.
Also: if your problem is solved, please take the time to mark your thread as SOLVED by going to the top of your first post, selecting "Thread Tools" and then "Mark thread as solved".
CF is only for display, not for change value in the cell.
You may set CF formula at E5 to =WEEKDAY(J3)=1
and set custom format ;;;\S\u\n\d\a\y to Display Sunday but Value still be what already in the cell.
You will need if or Vlookup formula at E5 for each value in your list.
Ahh, thanks. I just used your formula to highlight the cell when the date is a Sunday so I don't forget to mark it properly. That will help.
Thanks again!
Happy to help but I still think this is not a good idea to work.
Someone may forget to select the list in E5 and as it will only show Sunday no matter what value is in the cell.
Is it better to set custom format at J3 to mmmm d ddd, yyyy ?
I meant I'm going to make it highlight E5 when J3 is a Sunday so I know to change the rate. Maybe I'll even highlight the whole rate column so I HAVE to see it, then I'll layer the CF to remove the highlight when I put Sunday in E5.
I see, it just highlight then that is good. Thanks for the rep and mark topic solved.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks