full blog post: odyscope.com/general-excel/use-conditional-formatting-on-a-cell-based-on-another-cells-value/
Problem: You want to use conditional formatting on a cell or range, based on another cell's value.
Solution: Create a new conditional formatting rule and select the option to "Use a formula to determine which cells to format".
- Excel - Use Conditional Formatting on a Cell Based on Another Cell's Value ( Download)
- Excel How To: Format Cells Based on Another Cell Value with Conditional Formatting ( Download)
- Excel Conditional Formatting based on Another Cell | Highlight Cells ( Download)
- Excel Conditional Formatting with Formula | Highlight Rows based on a cell value ( Download)
- Conditional Formatting: Highlight Rows Based On Another Cell's Value ( Download)
- Microsoft Excel Conditional Formatting - Format cells based on another cell value ( Download)
- Excel: Change CELL COLOR based on VALUE of ANOTHER CELL ( Download)
- Excel Conditional Format Based on Another Cell | Highlight Entire Row with Conditional Formatting ( Download)
- Excel Conditional Formatting Based on Another Cell Tutorial ( Download)
- Using If then statement to change cell fill color (sort of) ( Download)
- Conditional Formatting in Excel Tutorial ( Download)
- Excel Conditional Formatting using Formulas ( Download)
- How To Format Cells Based On Another Cell Value in MS Excel ( Download)
- Conditionally Format When Two Columns have Same Value. Excel Magic Trick 1704. ( Download)
- How to format a cell based on another cell value -learn conditional formatting in Excel #excel ( Download)
