Help! Data Validation/Filters......

[genuinegal]

Hi all,

Ok, rather than me filtering text, or certain amounts, can i filter 'COLOUR SHADED CELLS'?

Thanks!

GG

 

[sebiwane]

not without using a macro

 

[Harvey]

http://www.mrexcel.com/board2/viewtopic.php?t=164854&highlight=filter+color+colour

 

[genuinegal]

Hi, i know, ive just found out that i can't do it unless i use the VBfeature...

I carried out a search on this board and found this link, it told me to copy and paste into a new window in VB...:

http://www.cpearson.com/excel/SortByColor.htm

Now, im not an expert when it comes to VB, but i managed to open a new window in VB (i am 'familiar with VB' but really need help..)/

Im stuck at at the bit where the paragraph starts:

'Of course, change the reference A1 to the first cell in the range. Use Edit, Fill, Down to fill this formula down to the entire range of data you want to sort....'

It says in these cells i'll see numbers 1-56, but i can't....

Anyone help me please!?

Thanks!

GG