Thanks Ken-hup

Apparently your only able to apply one conditional format to a cell. What
I'm trying to do is have a cell called day, if that cell value is Monday
it's pattern would be Blue, If Cell value = Tuesday then Green, etc.. It's
the same cell, just a different value and patern color I want to change
based on that value.

Thoughts?

Bob

"ken-hup" wrote:

Try Format / Conditional Formatting


"bbjr" wrote:

Hello,

Attempting to auto fill a cell with a color based on a selected word or
value in a pick list.

example: If selecting Tuesday the Cell would be blue, Monday the Cell
would be Yellow, etc..