Conditional formatting based on multiple values

Ask a question ziii - Last answered on Nov 27, 2016 at 11:09 AM by Mazzaropi

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


plus moins
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,, and place the download link here.

It gets faster and easier to help.
Leave a comment

Member requests are more likely to be responded to.

Members can monitor the statuses of their requests from their account pages.

A CCM membership gives you access to additional options.

Not a member yet?

Sign up now. It takes less than a minute and is completely free!