QUESTION : Related to this question, I am trying to compare a table of settings to identify some configuration issues. […]
Tag: conditional-formatting
Highlight birthday in a referenced cell
QUESTION : in Excel 2003 in worksheet1, I have a conditional formatting that highlights a cell when today is the […]
Formatting a column based on another columns cell TEXT (not value) in Excel [duplicate]
QUESTION : This question already has an answer here: Closed 9 years ago. Possible Duplicate: Excel 2010 conditional formatting: selectively […]
Multiple conditions in custom format
QUESTION : I would like to have multiple formatting conditions eg. 561 -> 561 1,100 -> 1.10K 2,220,000 -> 2.22M […]
How to conditional format ONLY the first row that meets a condition?
QUESTION : I have an amortization table with a date next to each row. How do I highlight ONLY the […]
Excel formula related to conditional formatting
QUESTION : Column A has 10 numbers expressed as percentages and is conditionally formatted to highlight the top 40%. I […]
conditional formatting of a cell with text value from two different cells and limits to entered figure
QUESTION : I came across an issue that is beyond my capability with conditional formatting. Here, I am entering a […]
Word – Excel Mail Merge Conditional Formatting
QUESTION : I’d like to mail merge student scores from Excel to Word. In addition I’d like to format the […]
Excel: Automatically extending conditional formatting to a new row added above data
QUESTION : I have a bunch of values across multiple rows and columns. They are structured so that each row […]
Highlight the duplicate rows in a Excel’s workbook
QUESTION : I have a workbook with multiple worksheets with values. The main values are A B C and in […]