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...
I tired this and it highlighted the entire column.....
I only need the cells to highlight when the cell in V and W on the same row are highlighted.
Example:
There is a highlighted cell in column W- cell W5- but nothing is highlighted for v5- I want X5 to highlight. Then v48 is highlight based on a different condition, but nothing in W48, I want X 48 to highlight. Regardless of the condition of why the cell in column V or W is highlighted, if it is hightlighted, I want the corresponding row cell for column X to highlight as well
Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?