View Single Post
  #1   Report Post  
markx
 
Posts: n/a
Default highlight/unhighlight (or color/uncolor) cells containing a specific character

Hi guys,

What is the best way to highlight (or even color) all the cells in a
worksheet (or even in a workbook) containing a specific character? For
exemple, I would like to make visually distinctive all the cells containing
somewhere a "?" character (or "mmm" string, or "!" mark, or "=" sign).

Are you aware of any special easy macro doing (and also undoing) this stuff?
Or do you have idea how to write a special formula to put in "conditionnal
formatting" part?

Thanks a lot for your input,
Mark