Can you conditional format based on information in cell comments?
 

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.

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