conditional formatting by or

[mohamedmatter]

i want to conditional formatting to column A:C
based jobs from c2:c6 , i attach file to example

 

[CJ_London]

something like this?

 

[mohamedmatter]

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]

Well look at this instead

https://www.youtube.com/watch?v=iFrBDqKEn4U

 

[Gasman]

Why not use Data Validation to only allow valid values.?

https://www.youtube.com/watch?v=SlWIgMFpsPg

 

[CJ_London]

agree - use data validation.

 

[June7]

Cross posted https://www.utteraccess.com/forum/index.php?showtopic=2051988&hl=

 

[June7]

Data validation and/or a dropdown of limited choices.

Why not migrate to Access database?