Formatting based on another cell's value

Conditional Formatting Based on Another Cell's Value

Conditional Formatting based on another cell's value allows you to dynamically highlight data based on conditions in a different cell. This is useful for tracking status, progress, or alerts.

Why Use This Feature?

Using another cell’s value for formatting makes spreadsheets more interactive and visually informative. It helps in decision-making by quickly drawing attention to relevant data.

How to Apply Conditional Formatting Based on Another Cell

1. Select the range of cells you want to format.
2. Go to Home > Conditional Formatting > New Rule.
3. Choose Use a formula to determine which cells to format.
4. Enter a formula that references another cell, such as: =B1>100 (if B1 contains a threshold value).
5. Click Format, choose a color, and press OK.

Examples

Highlight expenses over budgetUse =B1>A1 to highlight values exceeding a predefined budget.

Mark overdue tasksUse =A1 to highlight dates that have passed.

Secret Tip:

Use absolute and relative referencesUse $A$1 for a fixed reference, or A1 for dynamic row-based formatting.

Conclusion

Conditional Formatting based on another cell’s value helps create dynamic and informative spreadsheets. Use it to highlight key information and make better data-driven decisions.