Previous Topic Next Topic

Conditional formatting based on multiple values

Closed
ziii - Nov 27, 2016 at 01:34 AM
Mazzaropi Posts 1983 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Nov 27, 2016 at 11:09 AM
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 response

Answer 1 / 1
Mazzaropi Posts 1983 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 147
Nov 27, 2016 at 11:09 AM
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.

Similar discussions

help me to add particular cells
mathewmunna -
mathew munna -

2 responses
Clear cell contents based on value of another cell range using VBA
Tbonekiller -
Tbonekiller -

6 responses
Return Seq Values Until Blank value then return different set of seq values
lorieb63 -
TrowaD -

1 response
Fill adjacent cell with number from text answer
MitchP -
vcoolio -

20 responses
How to use conditional format based on text?
Leanne99 -
Mooseman -

26 responses