Identify Cell Color using a Function

Locky

New Member
Joined
Aug 28, 2002
Messages
2
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)
 

Excel Facts

Pivot Table Drill Down
Double-click any number in a pivot table to create a new report showing all detail rows that make up that number

Aladin Akyurek

MrExcel MVP
Joined
Feb 14, 2002
Messages
85,210
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.
 

Locky

New Member
Joined
Aug 28, 2002
Messages
2
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..
 

Forum statistics

Threads
1,181,821
Messages
5,932,258
Members
436,830
Latest member
Sochen

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top