Conditional Formatting with Multiple Cell Values

AmberTafolla 

Let's say you want to apply this to rows 2 to 100.

Select E2:E100. E2 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

=AND($E2<>"", $H2="F1IL", $J2<>"", $P2="")

Click Format...
Activate the Fill tab.
Select red as fill color.
Click OK, then click OK again.

Repeat these steps, but with the formula

=AND($E2<>"", $H2<>"F1IL", $J2="", $P2<>"")

and green as fill color.

With E2:E50 still selected, double-click the Format Painter button in the Clipboard group of the Home tab of the ribbon.

Click on H2, then on H2 and finally on P2.

Then press Esc to turn Format Painter off.