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.

For instance, you can use conditional formatting to highlight cells in red if their values fall below a certain number or use another color for values above a target. It can also be applied to ...

Formatting cells that meet specific criteria with a highlight color and/or font Applying different colors to different cells based on their values Applying color scales or gradients to visually ...

Conditional formatting in range Rows, columns, and a range of cells can be formatted to background color or changed in text based on certain conditions.

How to Use If-Then Excel Equations to Color Cells. If-Then rules allow you to create colorful business spreadsheets that do more than look pretty. Meaningful colors can help you and others ...

This week's tutorial covers a number functions in Google's Spreadsheet app, Google Sheets. Here we take a practical look at using weekdays in calculations, introduce 'if' statements and learn how to ...

Conditional Formatting In Google Sheets, as in other spreadsheet programs, you can set the formatting of a cell (text color, background color) based on the data contained within that cell. This is ...

The latest update to Excel for the web brings new options for cell colors, cell formatting, and tables. There's also a new printing experience on the way.

If you want to show negative numbers in red color in Google Sheets, then you can do this using conditional formatting and custom formatting.

Counting records or values in Microsoft Excel is easy. Counting individual cells by their fill color definitely isn't. Using an old function and a matrix tames the problem.