Jagger1
  Home FAQ Contact Sign in
 
 Advanced search
MATCHING GROUPS



more...
POPULAR GROUPS

more...
found 2 articles for 0.302 sec
Try conditional formatting looking for cells that = the value you are looking for and highlighting cells that meet the criteria. "JAgger1" <ss_jagger@hotmail.com> wrote in message news:1192761975.324035.123830@i38g2000prf.googlegroups.com... >I have spreadsheet with 1200 data points, I would like to search > these data points for certain value and have this value highlighted, > usually     

Group: microsoft.public.excel · Group Profile · Search for Jagger1 in microsoft.public.excel
Author: Laura Hast
Date: Oct 21, 2007 17:14

Hi Jagger, Another way may be to use conditional formatting. Say your data points are in A1 to A1200. Highlight A1:A1200 Go to Format>Conditional Formatting Set formula is =A1=$B$1 Click format and select a color from the Patterns tab And OK out Now whatever value you put in B1 will be highlighted in column A. You can also put this in C1 =COUNTIF(A1:A1200,B1) And it will count them
Show full article (0.59Kb) · Show article thread
    

Group: microsoft.public.excel · Group Profile · Search for Jagger1 in microsoft.public.excel
Author: MartinW
Date: Oct 18, 2007 22:15

Show full article (0.88Kb) · Show article thread