Download the featured file here: https://www.bluepecantraining.com/wp-content/uploads/2021/02/Format-row-based-on-value-in-another-cell.xlsx
In this video I demonstrate how to format an entire row in Excel based on a cell value. This can be achieved by using conditional formatting.
Topics covered in this video are, format entire row based on:
- A text value
- Partial match text value (contains)
- Numeric and date values (greater than, less than and between)
- Today's date
- A specific date
This video will answer the following queries:
How do you change a row color based on a text value in a cell?
How do I apply Excel conditional formatting to highlight row if cell contains text?
How do I highlight entire row in Excel with conditional formatting?
How do I change a row color based on a text value in a cell?
How do you conditionally format a row based on one cell?
How do I make a row a certain color based on value?
How do I highlight row if cell contains partial text?
How do I apply Excel conditional formatting to highlight row based on date?
------------------------