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...
What do the rules for columns V and W look like?
- 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.
