I also wanted to inform you that the conditional format will be applied to a
dropdown list. I currently have the list on sheet 2, but apparently
conditional formatting does not function across multiple sheets.

"TC" wrote:

Hi,

I want to create a conditional format which will change the color of a cell
depending on the user's choice. The cells which I am referencing are
scattered througout the worksheet (i.e. E84, E88, E90, etc.) How can I set
this conditional format to multiple cells? Or is there a way to set the
conditional format to text within a cell? any suggestions would be greatly
appreciated.

Thank you,