Forum home » Delegate support and help forum » Microsoft Access Training and help » access+training+courses - Counting number of coloured cells on a spreadsheet

access+training+courses - Counting number of coloured cells on a spreadsheet

ResolvedVersion Standard

Thu 4 Oct 2007, 10:23 Delegate Beenish said...

Beenish has attended:
Excel Intermediate course

Counting number of coloured cells on a spreadsheet

Hi

IS there a way of counting the number of cells that are coloured on an excel spread sheet so way of knowing the number of cells that are in colour.

thank you

Bee

Thu 4 Oct 2007, 15:27 Trainer Amanda said...

RE: Counting number of coloured cells on a spreadsheet

Hi Beenish

Thank you for your question.

The short answer is not easily - it would require writing some VBA code.

Sorry there's not an easy way to do this.

Amanda

Thu 4 Oct 2007, 16:06 Delegate Beenish said...

RE: Counting number of coloured cells on a spreadsheet

thanks....

Training courses

98.7 % recommend us

More live stats...

Training information:

Access tip:

Display current date & time in column of any width

The worksheet function =NOW() returns the current date & time. When entered into a column which is not wide enough to display the value NOW returns, the cell displays ###

View all Access hints and tips

access+training+courses - Counting number of coloured cells on a spreadsheet

Counting number of coloured cells on a spreadsheet

RE: Counting number of coloured cells on a spreadsheet

RE: Counting number of coloured cells on a spreadsheet

Access articles

Access tip:

Display current date & time in column of any width