Data Validation

[krosado]

I want the cell (and row) to highlight if a specific word on my data validation list is shown.

ex: B3: (validation list: Pending, Cancleation, Proceed)
If "Pending" is chosen, highlight the cell Yellow.

Thanks!

 

[jeffreybrown]

Highlight the range and in conditional formatting enter...

=$B3="Pending" >> pick format

 

[krosado]

Jeff,

It didn't work? Any ideas?

 

[jeffreybrown]

Jeff,

It didn't work? Any ideas?

Afaid more is required than "didn't work".

What did you try?
Steps you took?
What version of Excel are you using?
What cell holds the info to color off of?

http://www.contextures.com/xlcondFormat01.html

 

[krosado]

Thank you Jeff! I made it work!

Do you know if there is a way to make the formula an or statement? Ex: "Pending" or "Quote" then>>Format

 

[jeffreybrown]

Sure, try...

=OR($B3="Pending",$B3="Quote")

Or you could create a named range on your sheet somewhere and add the words you want to format, then

=MATCH($B3,FmtWords,0)

The named range is called FmtWords

This way you can easily interchange words you want to format or even extend the named range instead of adding a bunch of words to the OR statement