Forum Discussion
Having cells highlight in one sheet from another sheet
I want the cells in Column O on Sheet 2 to highlight (these are empty and just need to highlight to alert) if the word "yes" is typed into Column E of Sheet 1.
Select the cells in column O on Sheet 2 that you want to highlight conditionally.
In the following, I will assume that the selection begins in O2 and that O2 is 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=LOWER('Sheet 1'!E2)="yes"Replace Sheet 1 with the real name of that sheet.
Click Format...
Activate the Fill tab.
Select a highlight color.
Click OK, then click OK again.
