00:00I recently published a video on calculating days left from the deadline, along with color
00:04coding and flagging for overdue dates.
00:07The color coding can be customized in a self-formatting pop-up window like this.
00:10Press CTRL-1 and you open up Format Cell and this is where you define the colors.
00:15However, there was an interesting question about the possibility of using colors beyond
00:19the three options of red, blue and green.
00:22Well, we have a few more options for color and this is how you can define it.
00:25The first method is to use a standard color name as shown on the screen with a total of
00:29eight options available.
00:31If I missed out any other colors, please do let me know in the comments section.
00:34I've just changed red to magenta and this is what it looks like.
00:37The second option involves utilizing color index or color palettes.
00:40By typing the word color followed by a number, you'll have access to a range of 56 different
00:45colors to choose from.
00:46I have consolidated all the colors that I have outlined on this video here and this is what
00:50each of the color looks like.
00:51This first section is the standard color method here, as you can see I say black here and
00:56this is your color index or your color palette.
Comments