# Solved Using fill-in to color certian cells

Dell - inspiron 17.3" laptop - 4gb memor...
July 19, 2014 at 13:19:33
Specs: Windows 8.1, AMD A8/4.0Gb
 I have a list of combinations of numbers and letters that look like M00-123 or M00-1234.They are sorted in ascending order where each group of the same combination is separated by a blank line. I tried using conditional formatting to identify groups of four or more cells of the same combination so that they can be highlighted but that not did not work.Thank you.Brian W

See More: Using fill-in to color certian cells

#1
July 19, 2014 at 13:53:22
 Your still looking for Conditional Formatting, but now you need a Formula and the COUNTIF() function:1) Select your cell or range of cells: IE; A1 thru A1002) On the ribbon click Conditional Formatting3) Click on New Rules, it’s near the bottom of the dialog box.4) Click Use Formula to determine which cells to format.5) Enter the formula: =COUNTIF(\$A\$1:\$A\$100,A1)>=46) Click on the Format button7) Select the Fill Tab8) Select a pretty color9) Click OK10) Click OKSee how that works for you.MIKEhttp://www.skeptic.com/

Report •

#2
July 19, 2014 at 14:20:40
 Mike,Thank you for your suggestion; I will try it and get back to you. Can conditional formatting be used to insert a row line to separate blocks of the same numbers/letters from blocks of different numbers/letters?Thank you.Brian

Report •

#3
July 19, 2014 at 15:34:49
 used to insert a row line A formula can not insert a row, you will need a Macro.MIKEhttp://www.skeptic.com/

Report •

Related Solutions

#4
July 20, 2014 at 07:16:09
 Mike,Thank you for your assistance. Your suggestion worked as needed. In regard to inserting a row line, I know nothing about macros so I will insert the row lines manually.Thank you once again.Brian W

Report •

#5
July 20, 2014 at 07:47:03
 I will insert the row lines manually.Don't forget to use the Short-Cut key F4 which "Repeats the last command"Go to your first Insert location,click on the Row Number itself, so you select the entire row.Right Click and Insert a row.Next, go to your next insert locationclick on the Row Number itselfPress the F4 keyDoesn't save you a lot of keystrokes, but I find it to be a lot easier then constantly right clicking the mouse.You can also do Multiple Selections using the CTRL keyGo to your first Insert location,click on the Row Number itself.Go to your next Insert locationWhile holding down the CTRL key,click on the Row Number.You should now have Two rows selected, or hightlighted.Go to your next Insert locationWhile holding down the CTRL key,click on the Row Number.You should have Three rows selectedRepeat the above as many times as needed.Once you have all your Insert rows selected,right Click and select Insert and you shouldhave blank rows between your data, at the locations you wanted. MIKEhttp://www.skeptic.com/

Report •