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

Report •

#1
July 19, 2014 at 13:53:22
✔ Best Answer
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 A100
2) On the ribbon click Conditional Formatting
3) 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)>=4

6) Click on the Format button
7) Select the Fill Tab
8) Select a pretty color
9) Click OK
10) Click OK


See how that works for you.

MIKE

http://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.

MIKE

http://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 location
click on the Row Number itself
Press the F4 key

Doesn'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 key

Go to your first Insert location,
click on the Row Number itself.

Go to your next Insert location
While holding down the CTRL key,
click on the Row Number.

You should now have Two rows selected, or hightlighted.

Go to your next Insert location
While holding down the CTRL key,
click on the Row Number.

You should have Three rows selected

Repeat the above as many times as needed.

Once you have all your Insert rows selected,
right Click and select Insert and you should
have blank rows between your data,
at the locations you wanted.

MIKE

http://www.skeptic.com/


Report •

Ask Question