Formatting a column based on another columns cell TEXT (not value) in Excel [duplicate]
- Select column M. Check which cell is highlighted (let's assume
M1)
- Conditional Formatting \ New Rule
- Use a formula to determine which cells to format
- Type in the following formula
=J1="paid" (using the highlighted
cell's row number - remember M1)
- Choose your formatting, then validate.
- Repeat as needed for the other conditions and formats.
- for your other condition (see comment)
=and(or(j1="renew",j1="-"),M1>=today()+1)