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 Yesterday, 23:29 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: 110
C CJ_London Super Moderator Staff member Local time Today, 06:29 Joined Feb 19, 2013 Messages 16,553 Dec 25, 2018 #2 something like this? Attachments Capture.JPG 32.5 KB · Views: 195
M mohamedmatter Registered User. Local time Yesterday, 23:29 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, 06:29 Joined Sep 21, 2011 Messages 14,048 Dec 25, 2018 #4 Well look at this instead https://www.youtube.com/watch?v=iFrBDqKEn4U
Gasman Enthusiastic Amateur Local time Today, 06:29 Joined Sep 21, 2011 Messages 14,048 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, 06:29 Joined Feb 19, 2013 Messages 16,553 Dec 25, 2018 #6 agree - use data validation.
June7 AWF VIP Local time Yesterday, 22:29 Joined Mar 9, 2014 Messages 5,424 Dec 26, 2018 #7 Cross posted https://www.utteraccess.com/forum/index.php?showtopic=2051988&hl=
June7 AWF VIP Local time Yesterday, 22:29 Joined Mar 9, 2014 Messages 5,424 Dec 26, 2018 #8 Data validation and/or a dropdown of limited choices. Why not migrate to Access database?