ADVANCED MINIGEOGS
For this you'll need the alternative
If you look at the second sheet in the Excel file, which is called Excel Colours you will see details of all the 56 colours which are available in Excel. Each of these colours has a number. This sheet is a KEY for all the colours you can have.
You have the option to change from the default 10 colours. This involves a little bit of jiggery-pokery. Here's what you do...
Click into one of the cells in the 10x10 grid.
Hold down the ALT key and press F11.
You'll see a screen like the one below...
Click the image below to enlarge....
See the window on the right ? You'll see a section like this. It's written in VisualBasic...
Case 0: Num = 55: FontNum = 55
Case 1: Num = 3: FontNum = 3
Case 2: Num = 46: FontNum = 46
Case 3: Num = 5: FontNum = 5
Case 4: Num = 1: FontNum = 1
Case 5: Num = 27: FontNum = 27
Case 6: Num = 38: FontNum = 38
Case 7: Num = 43: FontNum = 43
Case 8: Num = 10: FontNum = 10
Case 9: Num = 40: FontNum = 40
So at the moment, if you type a '0' into a cell, it turns to colour number 55.
OK so far ?
Click back to the Excel file now and click on the tab which says Excel Colours.
This will show you that colour 55 is a dark blue...
So if you want to change one of the colours to suit your particular purposes, then change the number to something else. Do you need purple but not blue in your picture ? Purple is number 13. Change the line so that it says
Case 0: Num = 13: FontNum = 13
This will turn the cell purple, and then the number you typed in to purple too so it 'disappears'...
Please note that the key on the first sheet will not change by this method, but that's not a problem. I only copy the actual picture...
I am grateful to Paul from Fat Max: the
premier ICT site for ICT resources for assistance with
VisualBasic coding of the spreadsheet.
Check out the FatMax site by clicking HERE.