conditional formatting by or (1 Viewer)

mohamedmatter

Registered User.
Local time
Yesterday, 23:29
Joined
Oct 25, 2015
Messages
112
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

CJ_London

Super Moderator
Staff member
Local time
Today, 06:29
Joined
Feb 19, 2013
Messages
16,553
something like this?

 

Attachments

  • Capture.JPG
    Capture.JPG
    32.5 KB · Views: 195

mohamedmatter

Registered User.
Local time
Yesterday, 23:29
Joined
Oct 25, 2015
Messages
112
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
 

June7

AWF VIP
Local time
Yesterday, 22:29
Joined
Mar 9, 2014
Messages
5,424
Data validation and/or a dropdown of limited choices.

Why not migrate to Access database?
 

Users who are viewing this thread

Top Bottom