Forum Discussion
Re: Highlighting cells
3 Replies
Thanks
Select column X. X1 should be the active cell in the selection.
On the Home tab of the ribbon, click Conditional Formatting > New Rule...
Select 'Use a formula to determine which cells to format'.
Enter the formula=OR(AND($W1>0, $W1<=EOMONTH(TODAY(), 1)), AND($X1>0, $X1<=EOMONTH(TODAY(), 1)))
Click Format...
Activate the Fill tab.
Select a fill color.
Click OK, then click OK again.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?
