excel 2010 conditional formatting text values

3Point to Highlight Cells Rules and then select the type of criterion you want to use.
Using Excel 2010's new referencing option, it's easy to reference another sheet, as you'll a game of wrestling in 2011 see: Select the sales values in Northwest, that's D2:11.Figure F shows the formula-based settings.Or you could use the predefined Greater Than rule in Excel 20, which will automatically use the more accurate value.333333.Excel 2010's conditional formatting feature lets you reference different sheetssomething you couldn't do before.8: Find duplicates To find duplicate values or records, you can use a filter, but conditional formatting can pinpoint duplicate values on the fly.Highlight Cells Rules, when you choose this option you can highlight data that: is greater than a value is less than a value is between a high and low value is equal to a value contains a value is a date that occurs.If you dont like any of the pre-made formatting options, you can select.You specify certain conditions, and when those conditions are met, Excel applies the formatting that you choose.Using conditional formatting, you can alert users when it's time to reorder, as shown in Figure.Now, you just include the reference to another sheet as you would any other reference!Criteria options include Greater Than, Less Than, Between, Equal To, Text That Contains, A Date Occurring, and Duplicate Values.This rule, shown in Figure M, compares each value in column A to its counterpart in column.First, you don't have much flexibility with the actual formats.
The resulting dialog box will display a default format.




A menu appears with several different options for specifying the criteria.Figure S shows a common accounting tool known as cross-footing the process of double-checking totals by comparing subtotals across rows and columns in cell F16.In Excel 2003, Conditional Formatting is on the Format menu.If they're not the same, Excel highlights the value in column.As you can see, there is a box for you to enter the greater than number, and also a drop down list to select the highlight you want to apply to all cells greater than 5000.More Rules to get an idea of how the colour scale is set.Figure I This rule references the validation list instead of a literal string value.The G2 component creates a relative address, which updates with each row: G4, G5, G6, and.For example, Figure A shows a simple timekeeping sheet that highlights a workday that's greater than eight hours.