I have set conditional formating to highlight public holidays when a series of dates are calculated from a cell input for pay period week-endings. It works perfectly from a manual input, but, as I require data validation for pay period day endings and also selecting weekly paid or fortnightly paid, I have created a named list that gives a limited number of dates in the list for selection. That part works perfectly, but the conditional formatting does not work! when a selection is made from the list. So - everything works with manual input but does not work with list input. Can anybody suggest a work-around for this?
It would be easier if we could see a workbook with dummy data so we can evaluate your actual formula and how your data is laid out. Also, I'm not entirely sure which circumstances should trigger the conditional formatting. Could you elaborate with an example or two please?
Life is about perseverance. Remember: today's mighty oak tree is just yesterday's nut that held its ground.
If you like a post, please rate it with the scales icon (top right).
If you feel really indebted, please consider a donation to charity, such as Feed the Children or Habitat for Humanity.
Can give you the actual workbook, but where do I publish it to?
go advanced -- click on paperclip and upload your file
File attached, is protected but no password.
Regards
Cyanda
Last edited by cyanda; 11-29-2011 at 01:49 PM.
Further to my attached file Timesheet6d.xls.
Select cell C3, Select date 21/12/2011, W/ending 28/12/2011 panel should highlight 27/12/2011 and 28/12/2011. It does not.
Go to Cell D5, Tools/unprotect and check conditional formatting then go to C3 Data/Validation/Clear All then manually input 21/12/2011 and highlights (conditional formatting) appear.
To reset validation Lists & source=weekend
Last edited by cyanda; 11-27-2011 at 11:19 PM.
new post deleted
Last edited by cyanda; 11-27-2011 at 11:12 PM.
Change AJ1 to =Today(). Also, in the future, please help us help you by showing tabs, not protecting the worksheets (even if there is no password), etc. It's not a huge deal, but it makes no sense to make us go through extra steps to help you.
Life is about perseverance. Remember: today's mighty oak tree is just yesterday's nut that held its ground.
If you like a post, please rate it with the scales icon (top right).
If you feel really indebted, please consider a donation to charity, such as Feed the Children or Habitat for Humanity.
Thanks Darkyam. I did reset the options but uploaded the un-amended file. Sorry for that.
Regards
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks