Excel VBA Colour Function
This is an alternative to conditional formatting. The following will detect the colours Red, Yellow and Green in a particular cell. It will add the name of the colour – good for those colour blind individuals. It is a custom function so needs to used in conjunction with a formula or in a VBA procedure.
Read MoreFeatured Posts
Recent Posts
The Tennis Chart July 17, 2019
Smallman Interview July 15, 2019
Excel Summit South 2019 July 12, 2019
Sales Excel Dashboard June 14, 2019
Using the Wildcard with SUMPRODUCT May 30, 2019
Excel Dashboard by City May 16, 2019
Excel Timesheet Example May 9, 2019
When TRIM Doesn't Work in Excel May 8, 2019
Excel Now Has 3D Pictures May 1, 2019
Using Index as a Dynamic Range April 30, 2019