Having cells highlight in one sheet from another sheet

[mdayaylor]

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.

[#2]

@mdayaylor 

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.

[#3]

@Hans Vogelaar 

Thank you so much! It worked perfectly!