Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel software training london - Return Of Cells Based On Formatting

excel software training london - Return Of Cells Based On Formatting

ResolvedVersion Standard

Fri 13 Apr 2007, 10:54 Delegate Mark said...

Mark has attended:
Excel Advanced course
Access Introduction course

Return Of Cells Based On Formatting

Hi

I am trying to return a list of the codes within a database that have been filled with a yellow background.

i.e. only the cells within the main list that have a fill colour are extracted into a different sheet

Hope someone can help. Thanks

Mark

Wed 18 Apr 2007, 14:08 Trainer David said...

RE: Return Of Cells Based On Formatting

Mark

Excel does not have any built-in worksheet functions for working with the colors of cells or fonts. If you want to read or test the color of a cell, you have to use VBA procedure.

hope this answers your question.

regards

david

Training courses

98.7 % recommend us

More live stats...

Training information:

Excel tip:

Display Formulas Instead of Results in Excel 2010

By pressing Ctrl ~ once, Excel will display formulas rather than the results of the formulas. Press it again, and the results will appear again.

A much quicker and simpler way of displaying your formulas!

View all Excel hints and tips

excel software training london - Return Of Cells Based On Formatting

Return Of Cells Based On Formatting

RE: Return Of Cells Based On Formatting

Excel articles

Excel tip:

Display Formulas Instead of Results in Excel 2010