Conditional formatting based on multiple values [Closed]

Report
-
Posts
1914
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
April 7, 2021
-
Hello,

I want to color my cell if one of few drop down list is picked
for example: if appe or orange are getting picked, it needs to color it in green. the thing is its a lot more than 2 values, it can be much more, and I want to refer it to the cell itself

thanks

1 reply

Posts
1914
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
April 7, 2021
142
ziii, Good afternoon.

Without knowing more details it is very difficult to effectively help.

If there are really many possible values maybe setting up a table to do the research in time is one of the solutions.

If you prefer, save your file to some free website, www.sendspace.com, and place the download link here.

It gets faster and easier to help.

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!