I know I can do a find all that will list all instances of the variable; but is there a way that excel can automatically locate AND highlight that variable instead of me highlighting individually?Is there a ';find and highlight'; tool in excel 2003?
you could probably do it with conditional formatting, select the cells, rows, columns, entire sheet etc that you want to add highlights to. Then go to format-%26gt; conditional formatting. setup the conditions (probably if cell value is equal to your variable) then click the format link then patterns to select the color/style you want to highlight it. Anything that matches the conditions you put in will highlight itself, and if you add new data that matches the conditions it will highlight that too (as long as you don't change the format of the cells....can happen if you just copy/paste from another sheet, unless you right click and select paste special, then only paste the values)
Hope this helps.Is there a ';find and highlight'; tool in excel 2003?
i think no. don't wast your time by waitng the answer go to your work.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment