Conditional formatting can't be based on cell comments. Perhaps you
could insert the keywords into adjacent cells instead.

Jflyer wrote:
I would like to be able to color the cell background based on keywords typed
into the cell comments. Not having any luck on my own.


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html