Access Change Font Color Based On Value

I want the row color to change depending on the text that appears in the cell. It has a drop down list of predefined values. Set Colors and Conditional Formatting in visuals Power BI's visualizations have colors assigned automatically. Let me know if its feasible. Access 2010, I have this report with 11 columns and two of them are date formats (Start and End) date. Whenever an item in the list is updated with the status in the column, then the background color of the status column should automatically change depending upon the status. A row color is calculated dynamically based on multiple options, so there is no way to change it directly. Now I have tried to use conditional formatting and it causes excel to crash most of the time. Expressions¶. "Be it lack of access to education, stigma surrounding Menstrual Hygiene Management, forced child marriage, legal or medical inequality, or gender-based violence, there is a pressing need to support young women in their path to excellence. There are 2500 entries in the excel. The Label Wizard has options that allow you to select a font, font size, weight, and color. This example utilizes several advanced VBA functions to export an Access table to Excel. html:change invokes view class methods when an input value is changed. Send HTML Email from Access using VBA¶. This document provides instructions for integrating Zendesk data into Panoply. ok but now, this is a continuous form in which the condition is set, meaning if I change the back color for a text box on one record, then ALL the records show that text box back color. Assume that you have a form that formats the data or background color in a "Result" text box depending on the value of a target number and a comparison option. MS Access 2007: Conditionally change the background color of a text box on a Continuous Form. Microsoft To Do is one that manages to rise above the rest though. The following steps change the Detail Section of a form. Works in forms using conditional formatting, but won't seem to work in a report. Fox Sports is adding new exclusive programming covering the NFL, sports betting and Mexican soccer to its slate of Facebook Watch shows. Color Properties of a Range/Cell. Need to format font color in one report field based on value in another field It is an Inventory report. Whenever an item in the list is updated with the status in the column, then the background color of the status column should automatically change depending upon the status. If there are two measure values in a worksheet, can i specifically change the font color of one of the measure values out of the two. In C1 I calculate the diffrence in the values between A1 and B1, I then want C1 to change its color to green or red based on which value in the other cells is higher, so if A1's value is higher then B1, I was C1 to show that value and turn green. This returns a value dependent upon the font colour of a particular cell. Fonts: You can only set fonts on symbol layer types. Hi, Here is some code that will change the color of the text in a Textbox on a User Form, based on the difference in dates between Today and a date in a worksheet cell: If Worksheets(Sheet1). a Alpha component of the color (0 is transparent, 1 is opaque). Works in forms using conditional formatting, but won't seem to work in a report. Trigger, DataTrigger & EventTrigger. The font within the font family to use for the vertex labels. Other work has documented the honeybee's ability to learn compounds of stimuli. In this example, two style properties (padding and background-color) will be applied. Advanced Access Export Function To Excel Spreadsheet Using VBA Multiple Access Functions Export Data To An Excel Spreadsheet. In our project, we want to change the values in A1 to Item, B1 to Price, C1 to Quantity and D1 to Total. Label Change when Checkbox Checked. If Field 1 is B or C, then populate value from Field 3. You can also use this property on reports to create special visual effects when you print with a color printer. Option Explicit Private Sub CommandButton1_Click() ' DYNAMICALLY ADD MULTIPLE SHAPES IN EXCEL BASED ON A CONDITION. When you switch to another document theme, the cell styles are updated to match the new document theme. How can we set the background color of all the fields in a particular subform based on a dropdown value. Form SELECT elements () within your form can be accessed and manipulated in JavaScript via the corresponding Select object. DescriptionYou use the SUMIFBYCOLOR function to sum the values in a range that meet criteria that you specify. The Font object has many properties like the Color property and the Bold property. Change Font Color in Excel VBA - Examples. Hi, how i can change the output font and text size from this send email html results? THX (example html output from BOL) DECLARE @tableHTML NVARCHAR(MAX). You can create module level variables to share state &/or be constants. Learn how to do just about everything at eHow. Instead, you'll use basic CSS to define what color the text will appear in various elements on your page. I need these cells to be either red, yellow, or green based on the number of days until it expires. The problem is that the text will be followed by space and random numbers of a maximum of two digits. To apply a cell style, select the cells that you want to format. If you want to change the color of rows where the contents of the key cell starts with the indicated value or text, then you need to use =1 in the formula, e. Change background color based on cell value with Conditional Formatting command. You can also change a chart from a bar to a cylinder, etc. Add Combo Box. You can change the background color of a form by using the Back Color of the Property Sheet. change background color of combo box by selection. In Table Design view of the Workshops table, add Based on supplies as the Description for the CostPerPerson field. Formatting Access query values and editing column headings. How to dynamically change text color based on a background color. Each character within a font is created by using the same basic style. My task is to access that label in cs file and change the text from cs. This example was used to demonstrate how to change the color of all cells from one value to another. Select Highlight Cell Rules. "Be it lack of access to education, stigma surrounding Menstrual Hygiene Management, forced child marriage, legal or medical inequality, or gender-based violence, there is a pressing need to. It is interpreted the same way as the the font graphical parameter: 1 is plain text, 2 is bold face, 3 is italic, 4 is bold and italic and 5 specifies the symbol font. The color attribute is set to a random color from our random color function, while both the background-color and font-size are preset. The ZenBook 14 series has received plenty of upgrades in the recent past and this upgrade comes with Screen Pad 2. A Range object's Font property returns a Font object. Change background color based on cell value with Conditional Formatting command. Color = RGB(Red, Green, Blue) Process to change or set font color with RGB color model. User defined function. Learn how to quickly change the color of the entire row based on a single cell's value in your Excel worksheets. Text Dim CellValue As Integer = Convert. -In php I was changing the font color and not the background and was as simple as this below; now I want to change method and assign color to the bg instead of the font, my understanding is that I'm now messing with the way the rows colors are alternate in php and dataTables and the consequence is that when no condition is applied and I expect. You can also change a chart from a bar to a cylinder, etc. If later we add more and more rows to the Excel file, we only need to run this macro, the relative cells will change color accordingly. The team is based in the very heart of Bradford, in newly refurbished accommodation with dedicated desk space and meeting rooms. This is a good and straight forward way to conditionally change the stylesheet class. Where To Put VBA Code. The event can send the current text content as a string type dynamic argument. The code works, but it really slows my worksheet down when opening. I don't want to add any class in the template depending on the value. I need these cells to be either red, yellow, or green based on the number of days until it expires. The easiest and quickest way to handle this is to export the downloaded spreadsheet into an Access database, change the data structure of the imported table from text to numeric (integer or double). VBA code to change the color of a entire row based on text in specific cell For instance; if I choose "Cancelled" or "Shipped" in any cell from AB4 to AB2000) via a pull down list. He want to do this only for those lines which has font color of red. HI i need some help with text color in texbox using an expression,i have a report with some table and had a text with with positive numbers and negative number my requirement. Continuous form in continuous form. While you can change text color using the tag in HTML, this method is no longer supported in HTML5. This article discusses how you can access these features with a macro. If other chart is set already, it will be replaced with the new one (only one chart can be set in one element). Value Note: replace the [Text Box name] with the name of Text Box you want to access. This example utilizes several advanced VBA functions to export an Access table to Excel. Enable (this option disables the field so that it cannot be edited, and overrides the Background color and Font color settings). Nevertheless it is possible to change the column headings and the formatting appearance of data in each column. The ZenBook 14 series has received plenty of upgrades in the recent past and this upgrade comes with Screen Pad 2. When sending correspondence, add the prospect’s logos and perhaps even color scheme and font onto cover pages of any supportive documents sent as PDFs or e-proposals. How we can change row color, or any other styling characteristic, using conditional formatting? Solution. However, in a form that has a fixed layout, you can only change the background color of the field area at run time. For example, you may want to highlight all the rows where the quantity is more than 20 in green and where the quantity is more than 15 (but less than 20) in orange. I need to format the font color of a serial number based on who has the item. If the background is dark, light text is chosen. It's easy to implement. Because test manufacturers change the norms over time and keep resetting the average score to 100, it took some time before anyone noticed that the number of questions the average person was answering correctly was steadily increasing. You could check inside this converter if the name of your product is contained in the other list and return a text-value depending on what is needed. Provided by Data Interview Questions, a mailing list for coding and data interview problems. A Run object has a read-only font property providing access to a Font object. Field 3 - value Y. The Cell menu is the menu that pops up when you right click a cell:. A ComboBox displays a text box combined with a ListBox, which enables the user to select items from the list or enter a new value. For a complete set of the available properties, see the Font API documentation. You can also add form controls such as buttons, text input, combo box, etc on this tab. The Tab Control is a great way to get a lot of stuff into a small space on an Access form. text: The text to be displayed. , then this can be achieved by creating a rule in conditional formatting using a custom formula. Assume that you have a form that formats the data or background color in a "Result" text box depending on the value of a target number and a comparison option. Select the detail section of your report. Understanding Cell Values And Displayed Text. Is there a way to change the font color of each cell? I want to keep track of what data cells are good (green) and. If you want, you can change it. justify (constant) Controls text justification (the first character on a line determines how to justify the whole line). By using ng-model property in AngularJS we can get dropdownlist selected value and text in ng-change event. Exciting Family group Night Actions This Get Developing to some Large New PlaceWe know the simplest way very difficult it all is usually to grab youngsters to want to assist you to engage in family group activities — particularly as soon as they click the rather, um, specialized tween/teen ages. Instead of checking the color of each cell, you can also directly specify the range for which you want to change the color. Note: This material was originally published as part of the Opera Web Standards Curriculum, available as 48: Dynamic style - manipulating CSS with JavaScript, written by Greg Schechter. Field 4 - value based on previous fields What I am trying to get is to populate Field 4 based on the following criteria: If Field 1 is A, then populate value from Field 2. It's pretty basic, but this colors one text box based on it's 1:1 source cell. This code will produce the following result:. Whatever change you want to provide. That being said, my question is: how do I have a cell change color based on the proximity of a date from today. A font is a set of characters (text) represented in a single typeface. Form SELECT elements () within your form can be accessed and manipulated in JavaScript via the corresponding Select object. She is monitoring the frequency of contact with her clients and she wants Excel to automatically apply: One background color to cells where it has been less than 60 days since last contact; A different color when the time frame is between 60 and 90 days. Now what? Join 10 million other. Everything you ever wanted to know about VB6 Colors The default value for the BackColor of the form is always &H8000000F&, although the actual color that this value represents may vary from computer to computer. The Font property of the Range object in Excel VBA gives access to a lot of other properties. Style inheritance. -In php I was changing the font color and not the background and was as simple as this below; now I want to change method and assign color to the bg instead of the font, my understanding is that I'm now messing with the way the rows colors are alternate in php and dataTables and the consequence is that when no condition is applied and I expect. Vba To Change Font Color In Cells Based On Value - Excel I'm using some basic code below in an on Workbook Open event to format cells with a value less then 2 and less than 1 with a particular color. It seems the best way to do this is change the CSS style of TextField when 10 is entered into this field. Choose a font, font size, font weight, and color. Now that you have a variable representing the textbox, you can access its property to get the value typed in by the user. I need these cells to be either red, yellow, or green based on the number of days until it expires. If no text is entered in the Text field, the text object can be used for displaying a fixed image as a sheet object in the layout. Last week we discussed how to change the background color of a cell based on its value. Change Font Color in Excel VBA - Examples. So using [Color 25]General format, you can color the cell in the color that’s 25th in the Excel color Index. This wikiHow teaches you how to change font color in your HTML document. How to set different colors for items in ComboBox I have list of items for combobox, I need to set color to items, based on some conditions , so how to. Like the original, it is published under the Creative Commons Attribution, Non Commercial - Share Alike 2. You may have to register before you can post: click the register link above to proceed. This is a good and straight forward way to conditionally change the stylesheet class. Introduction. b Blue component of the color. Send HTML Email from Access using VBA¶. Some time we may need to highlight the table row based on specific cell / column value. Hi Shrikanth A, By changing control styles, you may achieve your requirement but this will lead to changes in CRM 2011 native web pages which is not supported and such unsupported code might break in future, once you update to future rollups. The CSS Object Model (CSSOM), part of the DOM, exposes specific interfaces allowing manipulation of a wide amount of information regarding CSS. You can change font color using the toolbars in this manner. He’d been living with his wife and two kids in. I would like to lock a range of cells based on the contents of a single cell. This is also where you can upload a logo, add/edit a title, add the date and time, etc. Microsoft Access / VBA Forums on Bytes. I need help with some VBA code. Set Alternative Row Background Color in an SSRS Tablix. Changing the background color. When you have your font choices set, select Save. How about this: create a cell with conditional formating that changes color depending on the value of a cell. color = 9851952 Then 'If it is blue, change it to black cell. We then compare that value to the current date (which we can get by using the Date) function. Now I have tried to use conditional formatting and it causes excel to crash most of the time. Color Properties of a Range/Cell. Share — copy and redistribute the material in any medium or format Adapt — remix, transform, and build upon the material for any purpose, even commercially. , then this can be achieved by creating a rule in conditional formatting using a custom formula. What can a lowly lichen reveal about a grisly murder case? Which common clothing item requires 5000 gallons of water to create? Where is the best place for a pilot to crash a malf. The color coding needs to change with a change in FruitName. So we need to make the point dependent on the category value! Starting point is the VBA to change point 3. Change cell color everytime a value is selected in dropdown list. If you try to change a color but you don't know the color code, you can visit the websites below. verticalMapping: Controls how the face and outline textures will be applied to the text object. I have previously submitted a similar post on how to find and highlight duplicate in Excel using VBA. Vba To Change Font Color In Cells Based On Value - Excel I'm using some basic code below in an on Workbook Open event to format cells with a value less then 2 and less than 1 with a particular color. To actually change a chart, after displaying its parent form in Design View, you can double-click it. So for instance a cell could contain the text "Due in 7 Days", "Past Due", or "Closed". I have a drop down combo box with Good, Fair, Poor as the selection options. If Column A has the same text as in column B then no colour should be applied to Column B. Although Microsoft Excel has functions that change the case of text, there are times when you may want to change text case programmatically. If mark is more than 80 then the entire row will change the colour to green, between 50 and 80 will be in yellow and less than 50 in red. I need it to change the color of cells based on their first value which is a text. These principles were developed based on years of experience in the field of usability engineering and they’ve became rules of thumb for human-computer interaction. The Expressions feature are available through the field calculator or the add a new column button in the attribut table or the Field tab in the Layer properties ; through the graduaded, categorized and rule-based rendering in the Style tab of the Layer properties ; through the expression-based labeling in the Labeling core application ; through the feature selection and through. The ListBox is populated with the contents of a range of cells on a worksheet. csv file and populating a Listview. VSFlexGrid Properties, Events, and Methods. What can a lowly lichen reveal about a grisly murder case? Which common clothing item requires 5000 gallons of water to create? Where is the best place for a pilot to crash a malf. Share — copy and redistribute the material in any medium or format Adapt — remix, transform, and build upon the material for any purpose, even commercially. The licensor cannot revoke these freedoms as long as you follow the license terms. A collection of formatting options that include a specified font, font size, font styles, font color, fill color, and borders. The easiest and quickest way to handle this is to export the downloaded spreadsheet into an Access database, change the data structure of the imported table from text to numeric (integer or double). Private Sub SetBlack_Click() Dim forecastTable As Range Set forecastTable = Range("B7:K17") For Each cell In forecastable 'Check the color of the cell If cell. In access report, I'm trying to change color of text in specific records based on the true/false value in another record. Understanding Cell Values And Displayed Text. However, there will be situations when you want to highlight an Entire row, based on certain conditions. Click on the OK button. You can change this by defining the environment variable IPYTHONDIR, or at runtime with the command line option -ipythondir. Change backgroud color for record listed in subform in continuous mode. Select Highlight Cell Rules. Need to format font color in one report field based on value in another field. The object consists of 3 properties which are style properties namely: color, background-color and font-size. Please note that this tool adds Static Text that the user cannot change. If the optional argument TOL is not entered, then the program will display the current value prior to checking control points. Click on the color you wish to use. Appreciate it, this did work but it presents another problem. Count unique distinct cells by cell font properties (font color, cell color, bold or italic) Custom function in cell D3: =CountC(A1:A20,C3) The user defined function matches the font properties in cell C3 with each cell in cell range A1:A20, then counts unique distinct values in those matching cells. The problem is that the text will be followed by space and random numbers of a maximum of two digits. The solution is simple: Use Color32 instead, which takes a value from 0 to 255. Although conditional formatting is one of Excel's most powerful features, it's a nuisance to turn it on and off through the menus and dialog boxes of the GUI. Learn more in our OnePlus TV review. Here is a way to format DataGrid cell foreground color based on the cell content: 1. Access 2010, I have this report with 11 columns and two of them are date formats (Start and End) date. I would like the form background to be based on a value in a field. Some of the new shows will include fan voting and the ability to submit live questions. Formatting Charts in Excel Once you create a chart it's easy to format and enhance your chart using Excel's menus and commands. I would like to change the background color based on each selection. For example, if cells filling with red background color in selection, then populate these cells with number 1, and for the blue background color cells, fill in number 0. Create a Conditional Formatting Rule. They allow you to do stuff that would normally be done in code-behind completely in markup instead,. Forms: Use ControlTipText to display textbox value. We’re looking to learn more about who uses GovTrack and what features you find helpful or think could be improved. Access Forms: Set different field background color based on text box value. It is interpreted the same way as the the font graphical parameter: 1 is plain text, 2 is bold face, 3 is italic, 4 is bold and italic and 5 specifies the symbol font. The Font object has many properties like the Color property and the Bold property. Text = "Yes" Else e. In this tip I will show you how to configure alternative row background colors in a Tablix and Matrix each with one simple example. I need these cells to be either red, yellow, or green based on the number of days until it expires. Appreciate it, this did work but it presents another problem. Change Font Color in Excel VBA - Examples. Each of them is intended for certain scenarios. This expression is saying if the Pay column value is less than or equal to $10. Count unique distinct cells by cell font properties (font color, cell color, bold or italic) Custom function in cell D3: =CountC(A1:A20,C3) The user defined function matches the font properties in cell C3 with each cell in cell range A1:A20, then counts unique distinct values in those matching cells. This module is used for retrieval of data in numeric form. ColorIndex = 3. Through ScreenItAgain. etc… Change Font Color in Excel VBA - Solution(s): We can change the font color by using Font. We have flexible, family friendly working arrangements. Some time we may need to highlight the table row based on specific cell / column value. TB_RegDeadline. verticalMapping: Controls how the face and outline textures will be applied to the text object. Microsoft Access / VBA Forums on Bytes. Here is a way to format DataGrid cell foreground color based on the cell content: 1. You can use the Design tab to change the color of the form, change fonts, or change the whole theme. How to Display a Default Text on Combobox. I've tried changing the enabled/locked values for the colored text box, doesn't fix it. See Formatting Codes For Headers And Footers in the VBA help files for a complete list of control sequences. Not only do these add a contrasting yet neutral color to the setup, but also reinforce. In this example, cell A1 is being selected. Rather than assigning colors to specific values I just need the report to alternate colors when the value of FruitName changes. It is interpreted the same way as the the font graphical parameter: 1 is plain text, 2 is bold face, 3 is italic, 4 is bold and italic and 5 specifies the symbol font. While you can change text color using the tag in HTML, this method is no longer supported in HTML5. The user-form contains various labels and I want to change the background colour of the label (so it matches that of the form). Hello, I am currently try to have cells change color according to their value. The two functions are applied in these examples to illustrate the color values of the text and the cell background colour. Excel VBA To Change A Chart Point Color Based On Its Label. How to Display a Default Text on Combobox. Here we want to check the cells in column C and rows starting from 2. Complete code with explanation is given. You can also change a chart from a bar to a cylinder, etc. You can change this by editing these labels. Tip: In GUI programming, you will handle custom events provided by the TextBox to know when to execute your logic rules. How to Change Text Color in HTML. You can then display crosses or check marks, boxed or unboxed, any size, any color, with background colors, and even use conditional formatting. I hope that is more clear. Changing another field with combo box (drop down) selection it easy to access in code and easy to change in the future. If you were looking for more of an accessibility-based "change the text color to make sure it has enough contrast. Change font color based on cell value with Select Specific Cells If you like to try some handy add-in tools, you can have a try on Kutools for Excel , there is a utility called Select Specific Cells can quickly select the cells meeting one or two criteria and then you can change their font color. Each color scale uses a two- or three-color gradient. When to use a value converter. All of the properties, events, and methods for the VSFlexGrid control are listed in the following tables. In previous section, I introduced how to send email in a MS Access VBA project. So if you wanted underlined green text, you would use a sequence like this: \[\e[4;32m\] We would then type in the prompt we want. A palette of Theme Colors and Standard Colors displays on the colors submenu. This is the snippet Convert a hex color string to an rgb color on FreeVBCode. The Font object has many properties like the Color property and the Bold property. In the Font section of the Home tab of the Ribbon, click the arrow of the Font Color button to display the list of colors and select one:. 00 change the text Red or if the Pay column value is greater than or equal to $20. Click on the down-arrow at the right side of the Font Color tool on the toolbar. Like the original, it is published under the Creative Commons Attribution, Non Commercial - Share Alike 2. Suppose we have a GridView and we want to change the color of the row based on particular cell value of the GridView. Click to display the Set Condition window. For the past year, SAP has provided in-game analytics to Team Liquid’s Dota 2 esports team. These dates are the expiration dates of access badges. Russ Binggeli. Tip: In GUI programming, you will handle custom events provided by the TextBox to know when to execute your logic rules. That is change the color to Green when Good is selected, Yellow for Fair and Red for Poor. Access displays a preview of the formatting as you select options. If you need to add interactive text field that the user can fill, save and print, please use Text PDF Form Field. MS Access 2003: Change the background color of a text box based on whether a value has been entered This MSAccess tutorial explains how to change the background color of a text box based on whether a value has been entered in a form in Access 2003 (with screenshots and step-by-step instructions). =( Is there a way to force the color change per record, and not for the whole form???. Instead, you'll use basic CSS to define what color the text will appear in various elements on your page. In previous section, I introduced how to send email in a MS Access VBA project. All of the properties, events, and methods for the VSFlexGrid control are listed in the following tables. [color] Used to apply a color to all values in a section of your format. Based on my experience during the short duration with the TV, here’s our OnePlus TV 55 Q1 Pro review. So for instance a cell could contain the text "Due in 7 Days", "Past Due", or "Closed". For example, you can change a chart from a flat column to 3-D. Write The Code. After clicking OK, click Preview in the Design view and we can see the report color changes. Access Forms: Set different field background color based on text box value. However, when she chooses a different font, all of the characters change to blank boxes (like the font isn't displaying correctly). g Green component of the color. If Column A has the same text as in column B then no colour should be applied to Column B. Formatting Access query values and editing column headings. Text = "Yes" Else e. This should get you started. That is change the color to Green when Good is selected, Yellow for Fair and Red for Poor. Colin Cowherd and Jason McIntyre will host a betting-themed show titled The. Select the Conditional Formatting button on the Home tab of the ribbon. Practical Learning: Introducing Labels. Zincy Lite is the latest popular theme in the wordpress. However, there will be situations when you want to highlight an Entire row, based on certain conditions. How we can change row color, or any other styling characteristic, using conditional formatting? Solution. Text = "No" End If End If End Sub. Each color scale uses a two- or three-color gradient. csv file and populating a Listview. Here I will explain how to use AngularJS to get dropdownlist selected value and text using ng-change event with example or use dropdown list ng-change event to get selected value and text using AngularJS with examples. The Tab Control is a great way to get a lot of stuff into a small space on an Access form. , then this can be achieved by creating a rule in conditional formatting using a custom formula. I am trying to write this into the Code window but so far I have been unsuccessful in getting it to work. I'm trying to make a field on a report highlight in red with white bold font on a report when it has an "S" populated. VBA to change font color in cells based on value I'm using some basic code below in an on Workbook Open event to format cells with a value less then 2 and less than 1 with a particular color. Need to format font color in one report field based on value in another field. You can also add form controls such as buttons, text input, combo box, etc on this tab. Hi, how i can change the output font and text size from this send email html results? THX (example html output from BOL) DECLARE @tableHTML NVARCHAR(MAX). A ColorStateList is an object you can define in XML that you can apply as a color, but will actually change colors, depending on the state of the View object to which it is applied. For example, you can change a chart from a flat column to 3-D. Step by Step Customizing RD Web Access 2012 R2 – Part 1 Posted on December 29, 2013 by Arjan Mensch — 103 Comments This is the first post in a series that focuses on customizing the RD Web Access 2012 R2 interface. theme A collection of formatting for text, colors, images, and graphical effects that are applied throughout a workbook to create a specific look and feel. Item SN Organization. The user-form contains various labels and I want to change the background colour of the label (so it matches that of the form). Hi, how i can change the output font and text size from this send email html results? THX (example html output from BOL) DECLARE @tableHTML NVARCHAR(MAX). In the Data Validation dialogue box, write =Color instead of Dress. You can change font color using the toolbars in this manner. Choose the color that you want and just copy the three values into the RGB(red_value, green_value, blue_value).