Cell Validation - Drop Down Lists and Text Formatting
Hi, I have a form in Excel that has a couple of drop down list options. I have my lists saved on a separate tab and i would like the options within one of the lists to repeat the specific text/cell formatting i have in place (each option has a different colour of text and cell fill applied, with mixed font sizes within the same cell). Is there a away o can do this without also adding conditional formatting to the cell that contains the drop down? CF doesn't quite give the result i am looking for as it doesn't mirror the mixed font sizing i have in place for the actual list. Would appreciate any help you can offer with this. Thank you JDatavalidation list based on 1 criteria.
Hi, Its now I wished the customer had dynamic arrays 😉 But without that. How do I make a list for use with data validation, based on 1 criteria? See picture. I would like to have new list (combining first name & Last name) if they have x in construction manager column. Best regards - Geir
Custom Data Validation
Hi, I'm quite an experienced Excel programmer, but I'm facing a problem with data validation I cannot understand. I got a custom data validation for cell 'K8'. The following formula works perfectly: K5=UND(--RECHTS(TEXT(K8;"0000");2)<60;RECHTS(TEXT(K8;"0000");2)/15=GANZZAHL(RECHTS(TEXT(K8;"0000");2)/15);$O8<=WENN(Dienstverhältnis="Lehrling";ZEIT(8;0;0);ZEIT(10;0;0));K8=GANZZAHL(K8);K8>=0;K8<=2400) The following doesn't work: K5=UND(--RECHTS(TEXT(K8;"0000");2)<60;RECHTS(TEXT(K8;"0000");2)/15=GANZZAHL(RECHTS(TEXT(K8;"0000");2)/15);$O8<=WENN(Dienstverhältnis="Lehrling";ZEIT(8;0;0);ZEIT(10;0;0));ODER(K8=GANZZAHL(K8);H8<>"");K8>=0;K8<=2400) The only difference in these 2 formulas is at the end ;K8=GANZZAHL(K8); ;ODER(K8=GANZZAHL(K8);H8<>""); GANZZAHL is german for INT and ODER is german for OR. When I put these 2 formulas in separate cells they show correctly TRUE and FALSE. E.g. if I write in K5 '805' it should not work. With the first formula the data validation fires, in the second formula not. Putting the 2 formulas in separate cells both show FALSE. Is there a character limit or something? The data validation dialogue doesn't show any error... Any help is very much appreciated! Best regards Andi
Select specific cells for data validation
Is there a way to select specific cells from a list that only show within a data validation set? For example: I have a list of fruits (Apple, Pears, Grape, Banana), but for this data validation I (the user) only want to show Apple and Grape so checkbox them so these are the only 2 fruits that appear in the drop down list in the 2nd tab. Obviously the earliest option is to just delete the fruits I don't want in the list but I want the list to stay the same, so it can be reused time and time again without having to reproduce the list. I have attached an example sheet with the contents that I am looking to use.
Excel Problem
Hi, I have a little problem with listing data from a database. I need to sort data by weeks, but i have dates so i said to Excel which date belongs to monthweek no.1,2,3.. you get the point. Then with that, i would like to list the data which are in the same week category(it has multiple columns, that's why i think it's difficult.) Thank you for help.Excel Problem
Hi, I have a little problem with listing data from a database. I need to sort data by weeks, but i have dates so i said to Excel which date belongs to monthweek no.1,2,3.. you get the point. Then with that, i would like to list the data which are in the same week category(it has multiple columns, that's why i think it's difficult.) Thank you for help.
IFS in data validation with drop down
Hello, I am trying to make an ifs statement that works with data validation. I want it to be: IFS(A1="Location1","Fred",A1="Location2","Mike",A1="Location3", *drop down of 3 names*) (If A1= Location 1 then A2 autopopulates to Fred, same with location 2 and Mike, Location 3 I want a drop down of 3 names in A2) Any ideas on how it would be able to work? Thanks!
