i want to conditional formatting to column A:C based jobs from c2:c6 , i attach file to example
M mohamedmatter Registered User. Local time Today, 15:18 Joined Oct 25, 2015 Messages 112 Dec 25, 2018 #1 i want to conditional formatting to column A:C based jobs from c2:c6 , i attach file to example Attachments Important.xlsx 8.4 KB · Views: 113
C CJ_London Super Moderator Staff member Local time Today, 23:18 Joined Feb 19, 2013 Messages 16,610 Dec 25, 2018 #2 something like this? Attachments Capture.JPG 32.5 KB · Views: 200
M mohamedmatter Registered User. Local time Today, 15:18 Joined Oct 25, 2015 Messages 112 Dec 25, 2018 #3 I'm sorry I can't explain what I want. if i enter any jobs not between this jobs"Teacher;Doctor;Nurse;Engineer;Judge" i want create conditional formatting to new job or any error when i write the above Jobs many thanks
I'm sorry I can't explain what I want. if i enter any jobs not between this jobs"Teacher;Doctor;Nurse;Engineer;Judge" i want create conditional formatting to new job or any error when i write the above Jobs many thanks
Gasman Enthusiastic Amateur Local time Today, 23:18 Joined Sep 21, 2011 Messages 14,282 Dec 25, 2018 #4 Well look at this instead https://www.youtube.com/watch?v=iFrBDqKEn4U
Gasman Enthusiastic Amateur Local time Today, 23:18 Joined Sep 21, 2011 Messages 14,282 Dec 25, 2018 #5 Why not use Data Validation to only allow valid values.? https://www.youtube.com/watch?v=SlWIgMFpsPg
C CJ_London Super Moderator Staff member Local time Today, 23:18 Joined Feb 19, 2013 Messages 16,610 Dec 25, 2018 #6 agree - use data validation.
June7 AWF VIP Local time Today, 14:18 Joined Mar 9, 2014 Messages 5,470 Dec 26, 2018 #7 Cross posted https://www.utteraccess.com/forum/index.php?showtopic=2051988&hl=
June7 AWF VIP Local time Today, 14:18 Joined Mar 9, 2014 Messages 5,470 Dec 26, 2018 #8 Data validation and/or a dropdown of limited choices. Why not migrate to Access database?