Use Excel custom formats to show emoji and text
How to use Custom Formats to change the colour of the cell, display an emoji or add text depending on the cell's contents.
top of page
Search
Miles Goodchild
Feb 15, 20222 min read
The 56 standard colours in Excel - the ColorIndex values or pallet
Whilst you can use conditional formatting and cell fill etc. to give you almost any colour in excel there is a "special" set of 56...
544 views0 comments
Miles Goodchild
Dec 6, 20211 min read
How to display a cell’s colour in Excel
It is not possible to directly access the colour of a cell in an Excel worksheet. Thus you can not write an expression such as “if the...
26 views0 comments
Miles Goodchild
Dec 5, 20212 min read
An easy way to make fully dynamic related drop-down boxes
In previous blog posts, we have seen how to make drop-down boxes driven by the entries in other cells and drop-down boxes. In this blog,...
4 views0 comments
Miles Goodchild
Nov 16, 20212 min read
How to produce a list of weekdays
How to display only weekdays in excel - three simple methods.
11 views0 comments
Miles Goodchild
Nov 15, 20211 min read
How to make many levels of dependent drop-down boxes
In the blog Excel – How To Make A Drop-Down Dependent On Another Drop-Down, I showed how to make the contents of a drop-down box...
7 views0 comments
Miles Goodchild
Nov 15, 20211 min read
How to make a dynamic drop-down box
In the blog (Excel – How To Make A Drop-Down Dependent On Another Drop-Down), I showed how to make the contents of a drop-down box...
2 views0 comments
Miles Goodchild
Nov 9, 20212 min read
Excel – how to make a drop-down dependent on another drop-down
Sometimes in Excel you want to make a selection dependent on another choice. For instance, you would like to select a country from a...
5 views0 comments
Miles Goodchild
Nov 8, 20212 min read
Automatically pulling data from other sheets into a dashboard
Situation A client had a single worksheet per project and wanted to pull data from each sheet into a single dashboard to give a view...
8 views0 comments
Miles Goodchld
Jun 8, 20214 min read
Working with Cell Colour, tint and shades in Excel VBA
How to use VBA to get the RGB colour for a cell and then adjust this colour by changing the shade or tint. Then colour another cell.
1,904 views0 comments
bottom of page