LinkBack URL
About LinkBacks
My conditional formatting and data validation will not fill-down. When I add a new column or row the conditional formatting and data validation will not copy down.
My conditional formatting and data validation will not fill-down. When I add a new column or row the conditional formatting and data validation will not copy down.
That's two statements, not a question. How would you have anyone investigate and diagnose the problem(s)?
Post a sample workbook that demonstrates the issues.
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
Sample spreadsheet attached. The first row works: after 60 hours the data validation pops up and indicates too many hours have been entered. This is not working in the rest of the spreadsheet.
Last edited by kcolaiacovo; 12-16-2020 at 04:29 PM.
To get the data validation and conditional formatting to automatically apply to inserted rows, you could move your totals to row 4 so that it is positioned above the rest of the data and then convert the range B6:P42 into a table.
Test by selecting cell P42, pressing the tab key and then entering a value greater than 60 in one of the cells in row 43.
I believe that the issue with the data validation is that it uses absolute referencing for rows.
Try selecting cells D7:O42 and then changing the Custom Formula to read: =SUM($C5:$O5)<=60
Let us know if you have any questions.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks