Now, to specify a conditional rule that changes the font color of a list item, do the following: With C1 selected, click the Home tab; C1 is the same cell where we put the data validation control.

Conditional formatting highlights key information in a spreadsheet so it’s easy to see at a glance. This beginner’s guide gets you started using conditional formatting.

Conditional formatting, as the name suggests, is used to format the content of a cell based on a certain condition. For example, you may use conditional formatting to highlight duplicate cell values.

Thanks to the linked cell property in Microsoft Excel, it's super easy to use the selected value as a condition in a macro or conditional formatting rule.

Excel allows defined functions to be executed in Worksheets by a user. Instead of a formula based on the color of a cell, it is better to write a function that can detect the color of the cell and ...

Want to to alternate row colors in Excel? You can apply color in alternate row & column in Excel spreadsheet using Conditional Formatting.