G Guest Jan 14, 2005 #1 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.
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.
D Debra Dalgleish Jan 15, 2005 #2 Conditional formatting can't be based on cell comments. Perhaps you could insert the keywords into adjacent cells instead.
Conditional formatting can't be based on cell comments. Perhaps you could insert the keywords into adjacent cells instead.