Freelance Project Requests Software Development in C# WPF Asp.Net Core Vba Excel Word SQL-Server EF Linq, UWP Net




Highlight the control element and in ribbon menu-> format-> conditional formatting


Comparison condition to a number

Dialog: Manager for Bedintern Formatting Rules

Open this with Edit rule

Then comes an input field for entering the condition formula


Only format cells for which applies


Expression is: [Controlname] = 123


Result: Conditional Formatting, Adjacent Field with Numeric Value

Now all cells are marked in color, which correspond to the condition in the adjacent field with value = 1


Comparison condition to a text


If you want to compare to a letter string, then the expression must be in quotes

Expression is: [control] = "abc"


Comparison result with text in adjacent cell




Access: Conditional formatting when another number field is empty or zero
Access: Conditional formatting Expression for adjacent fields
Ms Access: Set default value in vba


Contact for Jobs, Project Requests: