Forum Discussion
Highlighting cells
I need help with a formula for conditional formatting. Column v and w have data that are dates. This data is conditionally formatted to highlight when dates are past due or coming up to be expir...
The data in column X is irrelevant and is for viewing purposes only. I need the cells in column X to highlight if any cell in column V or W is highlighted in any color
If you use conditional formatting to highlight cells in column V and W, you may use conditional formatting with the same logic applied to column X.
- If I do that the entire column ends up highlighted because the conditions in column V and W are based on the dates. The highlight condition for the cell in column X cannot be based on the dates in column X. I just need the cells in column X to highlight IF and only IF the cells on that row for column V or W are highlighted.
Example. Cell W5 is highlighted green because that date is to expire next month. I need the cell X 5 to highlight BECAUSE W5 highlighted.For that you have two rules with exactly same formula, but applied in ranges in column W and X accordingly.
That's important column W shall be anchored in the formula, i.e. $W2, not W2. If W5 will be highlighted formula with same logic highlights X5.
If to keep the same color for both, only one rule with the formula as above is enough, but applied to $W$2:$X$18 for the example above.
