conditional-formatting
Conditional formatting to hide cell content even when printed
I would like to set up a conditional formatting setting that would hide the contents (the cell should look bl开发者_如何学编程ank) if the cell\'s contents is equal to another cell. Does anyone know of[详细]
2023-02-15 15:40 分类:问答Excel 2010 VBA: Set the color of a cell reference cell in previous column
I havemacro that populates a sheet, and copies values into a grid. I want to add conditional formatting to the cells, so that when they are updated if they become greater than the previous column they[详细]
2023-02-15 02:53 分类:问答WPF End-User Conditional Formatting Solutions
WPF makes it very easy to create conditional formatting rules at design time based the underlying bound data values.[详细]
2023-02-10 20:19 分类:问答Excel Conditional Formatting - Containing Multiple Matches
Trying to avoid VBA and use one Conditional Formatting rule. I 开发者_开发技巧want to apply a format to cells that contain one or more possible phrases.[详细]
2023-02-07 14:17 分类:问答Conditional FormatString or String.Format
I saw this post: How to Conditionally Format a String in .Net? The first part of the question points to the ability to use conditional formats. How is this done?[详细]
2023-02-01 19:12 分类:问答What's the best way to create a relative color algorithm for data in an HTML table?
I have an HTML table of data and I want to mimic the Excel Color scales for conditional formatting so it highlights the relative value across this set of data.[详细]
2023-01-29 11:13 分类:问答Reporting Services 2005 - Conditional Date Formatting not working
...so my sql view returns nvarchar as \'123456\' or \'JAN 11 2008 12:00AM\' (view does a union on two tables and casts date to nvarchar).[详细]
2023-01-27 05:47 分类:问答How to apply colour formatting to a Richtextbox *as the user types* (VB.Net)
I have a RichTextBox with an OnChanged event. The OnChanged event should look at each line in the RichTextBox and if the line is of prime length colour it red, otherwise colour it black. How do I do t[详细]
2023-01-20 04:43 分类:问答Apply conditional formating criteria in entire workbook (not just in a single sheet)
My goal is to eliminate duplicate value not only in sheet1, but to include values of she开发者_StackOverflowet2 and sheet3 for example! So when I type a value which is already existing in sheet1 (for[详细]
2023-01-07 03:51 分类:问答Excel find equal cells
lets say I have a xls sheet with just one column which has the following content: 1 2 3 3 4 5 5 6 You see there are some cells with equal content.[详细]
2023-01-07 00:37 分类:问答