Conditional Format Help Needed

[Tmayeux]

Hi Everyone,
I need help with a conditional formatting issue. I basically what excel to look at my column A and every time the data changes I want it to highlight the cells a different color. Pretty much similar to the Subtotals function but I need cell color differation not numeric calculations. I want the cell backround shaded differnt colors, not the font different though like shown below. Also I do not have the same number of each account number so I can't say change every 5th time.

See below:

Col A
600000
600000
600000
605000
607000
607000

Thanks!!

 

[Tmayeux]

I can get the first cell to work but I can't copy it correctly. Can you do a screen shot of your copying. My F5 Go to Special does not have "formats" as a choice. I have conditional formats though. It has to be my keystrokes.

I see you can do it, so it can be done. Almost there.

 

[danzon]

forget the copying part....start fresh.... remove all conditional formatting...

now..instead of applying it to just the first cell.... Select the entire COLUMN A (or whatever column has the data ) and apply the conditional formatting to the entire column

 

[Tmayeux]

Wow driving me nuts. (Not you, I am greatful for the help)

It does not work. It changes some random cells to blue but not the correct everyother chunck.

 

[danzon]

If you want to PM me your email address I will be happy to email you my little test file where it seems to be working

 

[danzon]

let me know if it helps... I am trying a few other possibilities

 

[danzon]

Here is a good solution from PETER SSs

http://www.mrexcel.com/forum/showthread.php?t=445551