Identify Cell Color using a Function

[Locky]

I have a 10,000 line spreadsheet containing 194 red (bold)coloured cells in column 1. Is there any function that will return a different value so that I can sort the coloured cells differently and thus delete the other 9000 odd cells.
(I am a newbie that was the Guru on Lotus123 in 1985 and now find myself in a time warp)

 

[Aladin Akyurek]

On 2002-08-29 02:21, Locky wrote:
I have a 10,000 line spreadsheet containing 194 red (bold)coloured cells in column 1. Is there any function that will return a different value so that I can sort the coloured cells differently and thus delete the other 9000 odd cells.
(I am a newbie that was the Guru on Lotus123 in 1985 and now find myself in a time warp)

Two options:

a) Use the condition under which some cells have been red colored as criteria in Advanced Filter in order to extract the intended records/cells.

b) Use the following in additional column:

=ExtCell("backgroundcolor",a2)=3

and sort the data on the additional column in descending order to get the read colored cells on top.

Do a Search on this site with Advanced Filter as keyword or ExtCell as keyword. ExtCell is user-defined function, the code of which is posted on this site in one of the threads you can find with Search.

 

[Richie(UK)]

Hi Locky,

Welcome to the board.

Try Dave Hawley's site here:
http://www.microsoftexceltraining.com/

Go to VBA/Custom Functions, the Sum by colour and Count by colour functions should get you started in the right direction.

HTH

 

[Locky]

On 2002-08-29 03:32, Richie(UK) wrote:
Hi Locky,

Welcome to the board.

Try Dave Hawley's site here:
http://www.microsoftexceltraining.com/

Go to VBA/Custom Functions, the Sum by colour and Count by colour functions should get you started in the right direction.

HTH

Thanks Ritchie...used the Color Ranking (with a Tweak) and it worked great..